Re: [SQL] setting select limit? - Mailing list pgsql-sql

From jwieck@debis.com (Jan Wieck)
Subject Re: [SQL] setting select limit?
Date
Msg-id m10Av7m-000EBRC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to RE: [SQL] setting select limit?  ("Neil Burrows" <maillist@remo.demon.co.uk>)
List pgsql-sql
>
> Hi,
>
> > You need v6.4.2-feature-patch which implement LIMIT option:
>
> Or alternatively if you can't or don't want to apply a patch, have a look at
> the
>
> SET QUERY_LIMIT TO x
>
> in Postgres 6.4

    It  is  commented  out  by default (#ifdef QUERY_LIMIT) and I
    recommend NOT to enable it.

    The implementation  of  SET  QUERY_LIMIT  hat  unwanted  side
    effects. If during the execution of such a query functions or
    triggers get  invoked,  the  query  limit  also  affects  the
    execution  of  their  queries.  That could damage triggers or
    give unpredictable results on functions.

    I'll ensure that the SET QUERY_LIMIT code will be removed  in
    v6.5.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

pgsql-sql by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] RULE questions.
Next
From: George Moga
Date:
Subject: Re: [SQL] Select max field