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 scott.marl...@gmail.com wrote: On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: Terry td3...@gmail.com writes: I am somewhat confused.  My app is detecting it as a serial

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

2010-03-04 Thread Terry
On Fri, Feb 26, 2010 at 4:52 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: Terry td3...@gmail.com writes: I am somewhat confused.  My app is detecting it as a serial data type but describing the table shows that its an

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

2010-02-26 Thread Terry
On Thu, Feb 25, 2010 at 9:42 AM, Terry td3...@gmail.com wrote: On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Feb 24, 2010 at 8:50 PM, Terry td3...@gmail.com wrote: Hello, I have an application that is doing something stupid in that it is tacking on

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

2010-02-26 Thread Scott Marlowe
On Fri, Feb 26, 2010 at 1:46 PM, Terry td3...@gmail.com wrote: On Thu, Feb 25, 2010 at 9:42 AM, Terry td3...@gmail.com wrote: On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Feb 24, 2010 at 8:50 PM, Terry td3...@gmail.com wrote: Hello, I have an

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

2010-02-26 Thread Terry
On Fri, Feb 26, 2010 at 3:16 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Fri, Feb 26, 2010 at 1:46 PM, Terry td3...@gmail.com wrote: On Thu, Feb 25, 2010 at 9:42 AM, Terry td3...@gmail.com wrote: On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed,

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

2010-02-26 Thread Tom Lane
Terry td3...@gmail.com 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 Scott Marlowe
On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane t...@sss.pgh.pa.us wrote: Terry td3...@gmail.com 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                    

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

2010-02-25 Thread Terry
On Wed, Feb 24, 2010 at 10:30 PM, Scott Marlowe scott.marl...@gmail.com wrote: On Wed, Feb 24, 2010 at 8:50 PM, Terry td3...@gmail.com 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.

[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

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

2010-02-24 Thread Tom Lane
Terry td3...@gmail.com 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

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

2010-02-24 Thread Scott Marlowe
On Wed, Feb 24, 2010 at 8:50 PM, Terry td3...@gmail.com 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