From: | "Matteo Centenaro" <gente_che_mixa(at)hotmail(dot)com> |
---|---|
To: | dev(at)archonet(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Insert and limit |
Date: | 2001-06-18 09:39:55 |
Message-ID: | F165uLn5U9T3TGJ2TUS00002d33@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I try to execute the select and all seem fine! The limit statement appear in
the right position.The prolang field is set to 18759392.
Have any other idea? Thanks
>From: Richard Huxton <dev(at)archonet(dot)com>
>To: Matteo Centenaro <gente_che_mixa(at)hotmail(dot)com>
>CC: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Insert and limit
>Date: Sat, 16 Jun 2001 08:12:21 +0100
>
>Matteo Centenaro wrote:
> >
> > I'm running 7.1.1
> >
> > I create the Pl/Pgsql function using Pgaccess the code is like this:
> > Insert into tab1 Select * from tab2 where id = xxxx limit var_name;
>
>Try something like:
>
>select prolang,prosrc from pg_proc where proname='copy_foo';
>
>from psql - I'd guess there's a glitch in the code pgaccess saved.
>
>- Richard Huxton
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Gordan Bobic | 2001-06-18 10:36:55 | Restoring database disk space requirements??? |
Previous Message | J.H.M. Dassen Ray | 2001-06-18 08:00:04 | Re: PDF Parsing and Indexing |