From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Matt Wagner <mwagner(at)envex(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Quick Pg/PLSQL question |
Date: | 2002-09-27 05:02:42 |
Message-ID: | 20020927050242.GA19477@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Sep 27, 2002 at 10:28:57PM -0500, Matt Wagner wrote:
> INSERT INTO transaction_summary VALUES (61, 1, "now", 0, 0, 0, 0);
> Very simple function, but I continue to receive errors, because of the "now"
> part. However, in the Programmer's Manual, it specifically uses "now" with
> double quotes in a couple examples. When executing the function, I continue
> receiving the following errors:
Simple error. The manual uses two quote's, not double quotes (ie, '' vs ")
which probably look the same in many fonts.
Two quotes counts as an escaped quote whereas a double quote make postgresql
think it's an identifier, which doesn't work.
Hope tihs helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-27 05:06:42 | Re: Quick Pg/PLSQL question |
Previous Message | Tom Lane | 2002-09-27 04:41:19 | Re: get date in binary number format |