From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | "jc_mich" <juan(dot)michaca(at)paasel(dot)com> |
Subject: | Re: Initializing variables from SQL query |
Date: | 2009-03-20 02:41:44 |
Message-ID: | 200903191941.44861.aklaver@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday 19 March 2009 5:25:03 pm jc_mich wrote:
> Hi all
>
> I'm new in PL/PGSQL developing, I'm trying to initialize a variable from a
> SQL query, this query counts some rows, I've made the next code, but it
> doesn't work.
>
> CREATE FUNCTION schema.myFunction() RETURNS BOOLEAN AS $$
> DECLARE
> counter RECORD;
> BEGIN
> SELECT * INTO STRICT counter FROM (SELECT COUNT (DISTINCT (rows)) FROM
> schema.table);
>
> I'm pretty annoyed, because I've found some examples that use this kind of
> variable initialization.
>
> Is there someone who know what I did wrong?
>
> Thanks!
>
> --
> View this message in context:
> http://www.nabble.com/Initializing-variables-from-SQL-query-tp22612191p2261
>2191.html Sent from the PostgreSQL - general mailing list archive at
> Nabble.com.
What is the error you are getting?
--
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | ray | 2009-03-20 04:08:53 | Re: Installation Error, Server Won't Start |
Previous Message | Merlin Moncure | 2009-03-20 01:37:35 | Re: PostgreSQL versus MySQL for GPS Data |