Re: [SQL] have you feel anything when you read this ?

2006-04-04 Thread Eugene E.
Stephan Szabo wrote: On Fri, 31 Mar 2006, Eugene E. wrote: Peter Eisentraut wrote: Eugene E. wrote: the problem is: you'll get this four byte sequence '\000' _instead_ of NUL-byte anyway. What you seem to be missing is that PostgreSQL data can be represented in textual and in binary fo

Re: [SQL] have you feel anything when you read this ?

2006-04-04 Thread Michael Glaesemann
On Apr 4, 2006, at 19:30 , Eugene E. wrote: Stephan Szabo wrote: On Fri, 31 Mar 2006, Eugene E. wrote: Peter Eisentraut wrote: No, that is still using the textual form. If you use PQexecParams and set the last argument to show you want binary data, you should get binary data. Documenta

Re: [SQL] have you feel anything when you read this ?

2006-04-04 Thread Stephan Szabo
On Tue, 4 Apr 2006, Eugene E. wrote: > Stephan Szabo wrote: > > On Fri, 31 Mar 2006, Eugene E. wrote: > > > > > >>Peter Eisentraut wrote: > >> > >>>Eugene E. wrote: > >>> > >>> > the problem is: you'll get this four byte sequence '\000' _instead_ > of NUL-byte anyway. > >>> > >>> > >>>Wha

[SQL] query to return hourly snapshot

2006-04-04 Thread Richard Broersma Jr
I orginally sent this email to the [novice] list but did not get any response. I am look for help in developing a query that will return the nearest process record that was logged at or after each hour in a day (i.e. hourly snapshot). Below are typical sample data. Also, I've included a

Re: [SQL] query to return hourly snapshot

2006-04-04 Thread Michael Fuhr
On Tue, Apr 04, 2006 at 05:58:26PM -0700, Richard Broersma Jr wrote: > I am look for help in developing a query that will return the nearest > process record that was logged at or after each hour in a day (i.e. > hourly snapshot). Are you looking for something like this? SELECT p.process, date_tr

Re: [SQL] query to return hourly snapshot

2006-04-04 Thread Richard Broersma Jr
Yes! Thanks you very much! --- Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Tue, Apr 04, 2006 at 05:58:26PM -0700, Richard Broersma Jr wrote: > > I am look for help in developing a query that will return the nearest > > process record that was logged at or after each hour in a day (i.e. > > hour

Re: [SQL] have you feel anything when you read this ?

2006-04-04 Thread Eugene E.
Stephan Szabo wrote: On Tue, 4 Apr 2006, Eugene E. wrote: Stephan Szabo wrote: On Fri, 31 Mar 2006, Eugene E. wrote: Peter Eisentraut wrote: Eugene E. wrote: the problem is: you'll get this four byte sequence '\000' _instead_ of NUL-byte anyway. What you seem to be missing is t