[ADMIN] order by question

Hi,All for example,I have a query as this select id,product_id from table_name where product_id in (6,3,4,10,7) order by . the results I want to get as bellow: idproduct_id.. 33...6... 40.

Re: [ADMIN] order by question

On Fri, Jun 19, 2009 at 05:50:25PM +0800, Tony Liao wrote: > Hi,All >for example,I have a query as this > select id,product_id from table_name where product_id in > (6,3,4,10,7) order by . >the results I want to get as bellow: > idproduct_id.

Re: [ADMIN] order by question

On Fri, Jun 19, 2009 at 6:50 AM, Tony Liao wrote: Hi,All for example,I have a query as this select id,product_id from table_name where product_id in (6,3,4,10,7) order by . the results I want to get as bellow: idproduct_id.. 33

Re: [ADMIN] order by question

I've never used "ORDER BY ." in any of my queries. If you want to get the records in order by id, you would simply do "ORDER BY id". If you want them by product it would be "ORDER BY product_id". Your best bet (depending on what you want) is likely "ORDER BY product_id, id" which

Re: [ADMIN] order by question

On Fri, Jun 19, 2009 at 3:50 AM, Tony Liao wrote: > Hi,All >        for example,I have a query as this >          select id,product_id from table_name where product_id in > (6,3,4,10,7) order by . >        the results I want to get as bellow: > idproduct_id..

[ADMIN] pg_dump exclude tables

I'm using postgresql 8.2.3 and am trying to run pg_dump with some tables excluded. It seems that no matter what I try pg_dump core dumps on me -- "Segmentation Fault (core dumped)". The -t flag works fine but -T does not. Even excluding just one table gives me the segmentation fault. This works fi

Re: [ADMIN] pg_dump exclude tables

"Mary Sipple" writes: > I'm using postgresql 8.2.3 and am trying to run pg_dump with some tables > excluded. It seems that no matter what I try pg_dump core dumps on me -- > "Segmentation Fault (core dumped)". The -t flag works fine but -T does not. > Even excluding just one table gives me the seg

[ADMIN] WAL archiving and backup TAR

Hello, I'm implementing WAL archiving and PITR on my production DB. I've set up my TAR, WAL archives and pg_xlog all to be store on a separate disk then my DB. I'm at the point where i'm running 'Select pg_start_backup('xxx');'. Here's the command i've run for my tar: time tar -czf /p

Re: [ADMIN] WAL archiving and backup TAR

torrez wrote: > The problem is that this tar took just over 25 hours to complete. I > expected this to be a long process because since my DB is about 100 > gigs. > But 25hrs seems a bit too long. Does anyone have any ideas how to cut > down on this time? Don't gzip it online? -- Alvaro

Re: [ADMIN] order by question

Thanks,All, To Tino,I want to order by IN condition "(6,3,4,10,7)". To Sergio,my answer is "Yes". To Kenny,I think this is not the result I want to get. To Scott,In database,there are thousands of products.the select query is generated by application,and it is no

Re: [ADMIN] order by question

On Fri, Jun 19, 2009 at 7:32 PM, Tony Liao wrote: > Thanks,All, >          To Tino,I want to order by IN condition "(6,3,4,10,7)". >          To Sergio,my answer is "Yes". >          To Kenny,I think this is not the result I want to get. >          To Scott,In database,there are thousands of  produ

[ADMIN]

Hi i am new to postgresql, please help me in implementation of Ldap in postgre in windows 2003 server. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

[ADMIN] Ldap in postgre in windows 2003 server.

Hi i am new to postgresql, please help me in implementation of Ldap in postgre in windows 2003 server. with regards khodadai -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin