Re: commenting sql code

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

In response to

Responses

Browse pgsql-novice by date

  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?