On 2/24/17 11:34 AM, Joel Jacobson wrote:
SELECT SomeCol, OtherCol, FooCol, BarCol, MyCol, ExtraCol, LastCol
INTO _SomeCol, _OtherCol, _FooCol, _BarCol, _MyCol, _ExtraCol, _LastCol
FROM Foo
WHERE Bar = 'Baz';
This is to avoid typos that are then visually easy to spot, thanks to
all chars being aligned.
Why not just use a record or the table composite? I'll commonly do stuff
like:
DECLARE
r record
BEGIN
SELECT INTO STRICT r
blah, foo, bar, baz
FROM pirate
;
IF r.blah THEN RAISE 'Yaaarrrrr!' END IF;
...
(Well, to be honest I always try to write pirate apps in plR... ;P)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
