On Sat, Aug 16, 2008 at 8:07 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Sat, Aug 16, 2008 at 6:11 PM, mark <[EMAIL PROTECTED]> wrote:
>> hi
>> if i execute this statement:
>>
>> select * from users where id in (2341548, 2325251, 2333130, 2015421,
>> 2073536, 2252374, 2273219, 2350850, 236731
On Sat, Aug 16, 2008 at 6:11 PM, mark <[EMAIL PROTECTED]> wrote:
> hi
> if i execute this statement:
>
> select * from users where id in (2341548, 2325251, 2333130, 2015421,
> 2073536, 2252374, 2273219, 2350850, 2367318, 2032977, 2032849, )
>
> the order of rows obtained is random.
>
> is there any
On Sat, Aug 16, 2008 at 1:28 PM, Decibel! <[EMAIL PROTECTED]> wrote:
> On Aug 12, 2008, at 3:15 PM, Jeff Gentry wrote:
>>
>> So I've seen the header file where the 1600 column limit is defined
>
>
> IIRC, that limit is directly related to block size in the header, so one
> possible fix is to increa
hi
if i execute this statement:
select * from users where id in (2341548, 2325251, 2333130, 2015421,
2073536, 2252374, 2273219, 2350850, 2367318, 2032977, 2032849, )
the order of rows obtained is random.
is there anyway i can get the rows in the same order as the ids in
subquery? or is there a d
On Aug 15, 2008, at 12:35 PM, William Garrison wrote:
Is there an easy way to write one single query that can alternate
between ASC and DESC orders? Ex:
CREATE OR REPLACE FUNCTION GetSomeStuff(_start integer, _count
integer, _sortDesc boolean)
RETURNS SETOF text AS
$BODY$
SE
On Aug 12, 2008, at 3:15 PM, Jeff Gentry wrote:
So I've seen the header file where the 1600 column limit is defined
IIRC, that limit is directly related to block size in the header, so
one possible fix is to increase block size. AFAIK anything up to 64K
blocks should be safe.
BTW, keep i
On Fri, Aug 15, 2008 at 5:59 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Ian Harding" <[EMAIL PROTECTED]> writes:
>> Is there any way to tell if a trigger or triggers are disabled on a
>> table? I was updating some data a week or two ago and must have
>> forgotten to re-enable the triggers. Took m
On Fri, Aug 15, 2008 at 9:42 PM, Amber <[EMAIL PROTECTED]> wrote:
> Dear all:
>We are currently considering using PostgreSQL to host a read only
> warehouse, we would like to get some experiences, best practices and
> performance metrics from the user community, following is the question list
