Question : Just came across a weird issue, whereby depending on how I create an index, an index name is […]
Tag: sql-standard
SQL: SELECT All columns except some
Question : Is there a way to SELECT all columns in a table, except specific ones? IT would be very […]
What does “ISO standard equivalent” actually mean?
Question : I’m reading about comparison operators. In the documentation, Comparison Operators Modified by ANY, SOME, or ALL it says […]
What is a “clob” or Character Large Object?
Question : I see in this post on listagg — Rows to Delimited Strings talking about SQL’s LISTAGG() clause ON […]
Equality in JOIN or WHERE clause? Efficiency and style
Question : Of the two queries below, which is the most efficient for postgresql? And which has better style in […]
Does the ANSI SQL Standard allow filters or parameters in JOIN conditions?
Question : Does the ANSI Standard find the following SQL sinppet syntactically correct? I am interested specifically in the last […]
Does the ANSI SQL Standard allow filters or parameters in JOIN conditions?
Question : Does the ANSI Standard find the following SQL sinppet syntactically correct? I am interested specifically in the last […]
Updating Multiple Tables with single Update query [duplicate]
Question : This question already has answers here: How to run update query on multiple table via joins simultaneously on […]
Why does information_schema have “YES” and “NO” character strings rather than booleans?
Question : I was taken by surprise to find that the is_nullable column for this query is typed as character […]
Using a CREATE TABLE AS SELECT how do I specify a WITH condition (CTE)?
Question : There is an old and deprecated command in PostgreSQL that predates CREATE TABLE AS SELECT (CTAS) called SELECT […]