Re: [GENERAL] select issue with order v8.1

2010-03-05 Thread Adrian Klaver
On Thursday 04 March 2010 2:59:45 pm Terry wrote: > On Fri, Feb 26, 2010 at 4:52 PM, Scott Marlowe wrote: > > On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane wrote: > >> Terry writes: > >>> I am somewhat confused.  My app is detecting it as a serial data type > >>> but describing the table shows that

Re: [GENERAL] select issue with order v8.1

2010-03-04 Thread Terry
On Fri, Feb 26, 2010 at 4:52 PM, Scott Marlowe wrote: > On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane wrote: >> Terry writes: >>> I am somewhat confused.  My app is detecting it as a serial data type >>> but describing the table shows that its an integer.  What am I >>> missing? >> >>> dssystem=# \d

Re: [GENERAL] select issue with order v8.1

2010-02-26 Thread Scott Marlowe
On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane wrote: > Terry writes: >> I am somewhat confused.  My app is detecting it as a serial data type >> but describing the table shows that its an integer.  What am I >> missing? > >> dssystem=# \d clients_event_log >>                                        Ta

Re: [GENERAL] select issue with order v8.1

2010-02-26 Thread Tom Lane
Terry writes: > I am somewhat confused. My app is detecting it as a serial data type > but describing the table shows that its an integer. What am I > missing? > dssystem=# \d clients_event_log >Table "public.clients_event_log" > Column |

Re: [GENERAL] select issue with order v8.1

2010-02-26 Thread Terry
On Fri, Feb 26, 2010 at 3:16 PM, Scott Marlowe wrote: > On Fri, Feb 26, 2010 at 1:46 PM, Terry wrote: >> On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote: >>> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe >>> wrote: On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote: > Hello, > > I h

Re: [GENERAL] select issue with order v8.1

2010-02-26 Thread Scott Marlowe
On Fri, Feb 26, 2010 at 1:46 PM, Terry wrote: > On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote: >> On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe >> wrote: >>> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote: Hello, I have an application that is doing something stupid in that it is

Re: [GENERAL] select issue with order v8.1

2010-02-26 Thread Terry
On Thu, Feb 25, 2010 at 9:42 AM, Terry wrote: > On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe > wrote: >> On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote: >>> Hello, >>> >>> I have an application that is doing something stupid in that it is >>> tacking on its own order clause at the end of the s

Re: [GENERAL] select issue with order v8.1

2010-02-25 Thread Terry
On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe wrote: > On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote: >> Hello, >> >> I have an application that is doing something stupid in that it is >> tacking on its own order clause at the end of the statement I am >> providing. >> >> For example, I am putti

Re: [GENERAL] select issue with order v8.1

2010-02-24 Thread Scott Marlowe
On Wed, Feb 24, 2010 at 8:50 PM, Terry wrote: > Hello, > > I have an application that is doing something stupid in that it is > tacking on its own order clause at the end of the statement I am > providing. > > For example, I am putting this statement in: > select > ev_id,type,ev_time,category,err

Re: [GENERAL] select issue with order v8.1

2010-02-24 Thread Tom Lane
Terry writes: > I have an application that is doing something stupid in that it is > tacking on its own order clause at the end of the statement I am > providing. > For example, I am putting this statement in: > select > ev_id,type,ev_time,category,error,ev_text,userid,ex_long,client_ex_long,ex_

[GENERAL] select issue with order v8.1

2010-02-24 Thread Terry
Hello, I have an application that is doing something stupid in that it is tacking on its own order clause at the end of the statement I am providing. For example, I am putting this statement in: select ev_id,type,ev_time,category,error,ev_text,userid,ex_long,client_ex_long,ex_text from clients_e