commenting sql code
От | joseph speigle |
---|---|
Тема | commenting sql code |
Дата | |
Msg-id | 20040220011349.GA4831@www.sirfsup.com обсуждение исходный текст |
Ответы |
Re: commenting sql code
|
Список | 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
В списке pgsql-novice по дате отправления: