From: | Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com> |
---|---|
To: | joseph speigle <joe(dot)speigle(at)jklh(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: commenting sql code |
Date: | 2004-02-20 11:13:23 |
Message-ID: | Pine.LNX.4.58.0402201208410.10784@moissac.leveque.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(dot)leveque(at)net6d(dot)com
http://www.net6d.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-02-20 14:42:55 | Re: commenting sql code |
Previous Message | daq | 2004-02-20 07:44:49 | Re: [SQL] Row counts/data changes. Any catalog table that has this info? |