Re: [GENERAL] Group By question

-0700, Jeff Lanzarotta wrote: > Hello, > > I have a table that looks something like this: > > SKU Dept Col1 Col2 Col3 > --- -- --- --- -- > 1112 3 > 2123 4 > 32

[GENERAL] Group By question

Hello, I have a table that looks something like this: SKU Dept Col1 Col2 Col3 --- -- --- --- -- 1112 3 2123 4 3210 1 4201 2 524

[GENERAL] Importing MySQL dump into PostgreSQL 8.2

Hello, I have a MySQL dump file that I would like to import into our PostgreSQL 8.2 database. Is there a way to do this? Thanks. -Jeff

Re: [GENERAL] Question about a query with two count fields

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jeff > Lanzarotta > Sent: Tuesday, September 11, 2007 8:51 AM > To: PostgreSQL GENERAL List > Subject: [GENERAL] Question about a query with two count fields > > Hello, > >

[GENERAL] Question about a query with two count fields

Hello, I am in need of producing a query that has two count fields in it... Something like: select to_char(ts, 'MM/DD/') as "day", str, proc, (select count (*) as good from foobar where z != 0), (select count (*) as bad from foobar where z = 0) from foobar where str != 9 group by str, da

Re: [GENERAL] Selecting rows where timestamp between two timestamps

Well that was easy enough... Thanks! Michael Fuhr <[EMAIL PROTECTED]> wrote: On Mon, Aug 13, 2007 at 07:16:30AM -0700, Jeff Lanzarotta wrote: > select * from foobar where ts between now() and now() - interval '5 days' > > btw, the column ts is defined as: > >

[GENERAL] Selecting rows where timestamp between two timestamps

Hello, I am trying to get this query to work with no luck... select * from foobar where ts between now() and now() - interval '5 days' btw, the column ts is defined as: ts timestamp with time zone NOT NULL DEFAULT now() No rows are returned, but I know there are at least 100 rows that should

Re: [GENERAL] How does server handle clients that disconnect ungracefully?

OK, that is what the other fellow said... It depends on the TCP/IP stack... Thanks again for the clarification. --- Magnus Hagander <[EMAIL PROTECTED]> wrote: > On Tue, Apr 24, 2007 at 06:55:12AM -0700, Jeff Lanzarotta wrote: > > OK, thanks. I figured the server would at som

Re: [GENERAL] How does server handle clients that disconnect ungracefully?

> On Tue, Apr 24, 2007 at 05:53:02AM -0700, Jeff Lanzarotta wrote: > > Hello, > > > > I am writing an application that reads information from my > PostgreSQL > > database. If I cause the program to crash and the program ends > without > > gracefully disc

[GENERAL] How does server handle clients that disconnect ungracefully?

Hello, I am writing an application that reads information from my PostgreSQL database. If I cause the program to crash and the program ends without gracefully disconnecting from the database, there is an open connection still left in the database. How does the PostgreSQL server handle clients tha