Amit Langote wrote: >> Is the following behavior perceived fix-worthy? >> >> >> -- note the '1's in the outputs >> >> postgres=# CREATE TABLE test AS SELECT; >> SELECT 1 >> >> postgres=# insert into test select; >> INSERT 0 1 > > Or maybe, it just means 1 'null' row/record and not no row at all?
Right, I'd say you end up with a table with two 0-tuples. Maybe odd, but it shouldn't be a problem. Yours, Laurenz Albe -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
