| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | joseph speigle <joe(dot)speigle(at)jklh(dot)us> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: quote style in buffer |
| Date: | 2004-02-01 16:16:33 |
| Message-ID: | 19166.1075652193@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
joseph speigle <joe(dot)speigle(at)jklh(dot)us> writes:
> I can't seem to find the comment for an sql file
> drop function dups();
> -- joe speigle
> -- Feb 1 2004
> CREATE FUNCTION dups() RETURNS int4
> AS 'SELECT 1 as RESULT' LANGUAGE 'sql';
> this always stops after the first line.
It looks just fine as you've shown it. Define "stops" --- what did you
do exactly, and what happened exactly?
The only theory that comes to mind right away is that what you think are
newlines are not really, so that the database is seeing the file as one
long line.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-01 17:02:50 | Re: simple update closes connection. why? |
| Previous Message | Lawrence Smith | 2004-02-01 16:00:03 | Re: Q: Reclaiming deleted space in data files |