From: | joseph speigle <joe(dot)speigle(at)jklh(dot)us> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | commenting sql code |
Date: | 2004-02-20 01:13:49 |
Message-ID: | 20040220011349.GA4831@www.sirfsup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi,
I was wondering again (I'd asked this a while back but can't find in archives) ..... how can I make an sql comment?
For example this script .....
*******************************************************
select mazurek(1);
-- test
SELECT count(*) as master_count FROM master;
SELECT count(*) as detail_count FROM detail;
*******************************************************
gives me this result:
*******************************************************
test=# \e mazurek_test.sql
mazurek
------------------------------------------
less references in master than in detail
(1 row)
test=#
*******************************************************
which is the return value from the function, and all further output is killed by the comment.
so it produces no output after the --test.
WASN'T THAT A COMMENT?
I have also tried.... --test (without the space)
to no avail
joe
--
speigle
www.sirfsup.com
From | Date | Subject | |
---|---|---|---|
Next Message | joseph speigle | 2004-02-20 01:17:24 | outputting commands to spool |
Previous Message | kynn | 2004-02-20 00:23:29 | psql hangs after "drop table ..." |