Re: [SQL] [GENERAL] Queyring for columns which are exist in table.

2011-01-27 Thread Thom Brown
hat is available beforehand. Is there any logic to which tables have the additional column and which ones don't? For example, do all tables with the additional column have a name containing a date after a certain point in time? -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion

Re: [SQL] [GENERAL] Queyring for columns which are exist in table.

2011-01-27 Thread Thom Brown
On 27 January 2011 07:52, Santosh Bhujbal (sabhujba) wrote: > Hi All, > > > > I want to fire a query such that if the particular column does not exist > then query should return some default value. Why do you want to do this? What is it you using this for? -- Thom Brown T

[SQL] Re: [GENERAL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL

2010-06-25 Thread Thom Brown
On 22 June 2010 11:48, venkat wrote: > Dear All, > >   I want to insert and retrieve multilingual (Hindi) into > database.is PostgreSQL supports that ?if it is ... please guide me how to > enable multilingual in the table. > >     I am waiting for your great response. > Thanks and Regards, > Venka

Re: [SQL] Lag and lead window functions order by weirdness

2009-10-17 Thread Thom Brown
2009/10/10 Thom Brown > I've had a look at examples of lag and lead window functions with order by > inside the OVER clause, and I'm confused as to why it influences the overall > order in the output. > For example (for a table called category with incrementing id numbers u