YugabyteDB Tips
  • Home
  • About
  • Featured Videos

Category: SQL Functions

YugabyteDB Tips > SQL Functions

Create Your Own IS_DATE Function

Jim KnicelyOctober 13, 2023

YugabyteDB is a PostgreSQL-compatible distributed database that supports the majority of PostgreSQL syntax. YugabyteDB also inherits all of the awesome built-in function that […]

Read More

Using yb_table_properties To Display Tablet Count of a Table’s Primary Key Index

Jim KnicelyMay 12, 2023

We learned in a previous tip that the YB_TABLE_PROPERTIES function can be used to display the number of tablets for a YSQL […]

Read More

REMOVE CONSECUTIVE REPEATED CHARACTERS FROM A STRING

Jim KnicelyMarch 30, 2023

A regular expression is a character sequence that is an abbreviated definition of a set of strings (a regular set). Regular Expressions have […]

Read More

Generate a Random JSONB String (with Specific Keys)

Jim KnicelyMarch 8, 2023

Whenever you are populating table columns with dummy data you’ll probably need to generate some random JSONB strings. Although there is not […]

Read More

Generate a Random JSONB String

Jim KnicelyMarch 7, 2023

Whenever you are populating table columns with dummy data you’ll probably need to generate some random JSONB strings. Although there is not […]

Read More

Posts navigation

Older posts
Newer posts

NOTICE

This site is not affiliated, endorsed or associated with YugabyteDB. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.

Find Us

Address
Here!

Hours
24×7

Recommended YugabyteDB Links

  • Home
  • Key Concepts
  • Docs
  • Blog
  • Forum
  • Content Library
  • Support



YugabyteDB Tips

Copyright 2025 - Knicely/Li