Re: commenting sql code

In your example you must use \i and not \e



On Thu, 19 Feb 2004, joseph speigle wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com