Hi all,
I'm puzzled by some behaviour of the ROW constructor that I noticed when I was playing around.
From the documentation (https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS), we
have
NUMBER 1
> SELECT ROW(1,2.5,'this is a test') = ROW(1, 3, 'not the same') AS test1;
result:
> test1
> f
This is fine.
and then
NUMBER 2
> SELECT ROW(1, 2.5, 'this is a test') = (VALUES (1, 2.5, 'this is a test')) AS test2;
result:
> test2
> t
OK - notice the equivalence of a ROW constructor and a VALUES clause.
So, then I create this table:
> CREATE TABLE test
> (
> a INT NOT NULL,
> b INT NOT NULL,
> c TEXT NOT NULL
> );
and then tried:
NUMBER 3
> INSERT INTO test ((ROW (1, 2.4, 'test...')));
and I get:
> ERROR: syntax error at or near "ROW"
> LINE 1: INSERT INTO test ((ROW (1, 2.4, 'test...')));
I tried various permutations of brackets and whatnot but nothing doing.
My question is that if a ROW constructor works for a VALUES clause in statement NUMBER 2, then why not NUMBER 3?
TIA and rgs,
E.
