dbaston wrote
> I'm wondering if this is expected behavior?
Yes.
The proper way to handle this is by putting the SRF in the FROM clause.
If you must have it in the select clause you should do this:
WITH srf_call (
SELECT srf_function() AS srf_result
)
SELECT (srf_call.srf_result).* FROM srf_ca
> On 26 Aug 2001 13:50:16 -0700, Cody <[EMAIL PROTECTED]> wrote:
> > I just finished reading Bruce M's book, so this thread confuses me,
> > esp. Jan's posts. I take full heed of the need for application level
> > user/thread management, but I was interested in using a parallel
> > set-up in PG (
On 26 Aug 2001 13:50:16 -0700, Cody <[EMAIL PROTECTED]> wrote:
> I just finished reading Bruce M's book, so this thread confuses me,
> esp. Jan's posts. I take full heed of the need for application level
> user/thread management, but I was interested in using a parallel
> set-up in PG (however re
I prefer the way Notes (for example) handles it. All
records/documents/views are in read-only mode until the user indicates
they actually want to edit. They then exclusively lock that record for
editing, with optional timeouts (in case their workstation crashes or
whatever).
This turns out to
> >But the question itself tells that you're about to implement
> >a major design error in your application. Holding database
> >locks during user interaction IS A BAD THING. Never, never
> >ever do it that way. And anybody telling you something
> >diffe
"Thomas T. Thai" <[EMAIL PROTECTED]> writes:
> On Fri, 22 Jun 2001, Tom Lane wrote:
>
> > "Thomas T. Thai" <[EMAIL PROTECTED]> writes:
> > >> Use a union query:
> > >>
> > >> select rec_id, path, '' as link, name from cat_cat
> > >> UNION
> > >> select rec_id, path, link, name from cat_alias
>
On Fri, 22 Jun 2001, Tom Lane wrote:
> "Thomas T. Thai" <[EMAIL PROTECTED]> writes:
> >> Use a union query:
> >>
> >> select rec_id, path, '' as link, name from cat_cat
> >> UNION
> >> select rec_id, path, link, name from cat_alias
>
> > there is no way to do this in a generic DBI way? i need f
"Thomas T. Thai" <[EMAIL PROTECTED]> writes:
>> Use a union query:
>>
>> select rec_id, path, '' as link, name from cat_cat
>> UNION
>> select rec_id, path, link, name from cat_alias
> there is no way to do this in a generic DBI way? i need for this to work
> across diff kind of DBs.
Huh? That
On Fri, 22 Jun 2001 [EMAIL PROTECTED] wrote:
>
>
> Use a union query:
>
> select rec_id, path, '' as link, name from cat_cat
> UNION
> select rec_id, path, link, name from cat_alias
there is no way to do this in a generic DBI way? i need for this to work
across diff kind of DBs.
>
> Notice
SELECT * FROM employee WHERE empname LIKE 'P%'
the above would work only if you want to search for people w/ names starting
w/ P
Mike
- Original Message -
From: "Marcelo Pereira" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 5:23 AM
Subject: Select
> Hi All
On Wed, 14 Feb 2001 15:03, you wrote:
> It's version 7.0.3
>
> Here's the output for the selects using explain below.
> We had planned to do all of the optimization later. We just haven't had
> time to get to it yet. Could that be the problem?
>
> Anyhow here's the info. Please let me know if you
It's version 7.0.3
Here's the output for the selects using explain below.
We had planned to do all of the optimization later. We just haven't had time
to get to it yet. Could that be the problem?
Anyhow here's the info. Please let me know if you need more information.
Appreciatively,
Matt Fried
Thanks all, it's working great now.
Cheers. :-)
[EMAIL PROTECTED] wrote:
> As per the documentation at:
> http://postgresql.planetmirror.com/users-lounge/docs/7.0/user/c40874113.htm#AEN4207
>
> When using SELECT in a PL/PGSQL function, you must either SELECT .. INTO or
> use the PERFORM query i
Tom Lane writes:
> Felipe Alvarez Harnecker <[EMAIL PROTECTED]> writes:
> > Hi, I wonder if one must activate the LIMIT clause somewhere,
>
> uh ... no ...
>
> > bacause for me it does nothing.
>
> Details? What query did you issue exactly, and what did you get?
>
>
Felipe Alvarez Harnecker <[EMAIL PROTECTED]> writes:
> Hi, I wonder if one must activate the LIMIT clause somewhere,
uh ... no ...
> bacause for me it does nothing.
Details? What query did you issue exactly, and what did you get?
regards, tom lane
Tom Lane writes:
> g <[EMAIL PROTECTED]> writes:
> > Use the limit clause.
> > SELECT message_text FROM messages ORDER BY creation_date LIMIT $limit,
> > $offset.
>
> > LIMIT 10, 0 gets you the first batch.
> > LIMIT 10, 10 gets you the second batch.
> > LIMIT 10, 20 gets you the third,
16 matches
Mail list logo
