[SQL] Problems with ODBC connections

2012-02-27 Thread Sandeep Reddy
Hi, I am completely new to postgres and I have some problems with ODBC connection. 1) I am running postgres server in Fedora Linux, and I am planning to connect server from windows client. 2) I have installed 64bit version of postgresql ODBC drivers 3) I am making sure that my postgres is running w

Re: [SQL] SQL View to PostgreSQL View

2012-02-27 Thread Adrian Klaver
On Sunday, February 26, 2012 10:50:16 am Rehan Saleem wrote: > Hi , > I am trying to convert sql > view to postgresql view but i am getting the > following error i dont know how > to handle dbo. > in postgresql and when i remove dbo. from table name then view got created > but it does not show any

Re: [SQL] Problems with ODBC connections

2012-02-27 Thread Adrian Klaver
On Saturday, February 25, 2012 10:05:07 am Sandeep Reddy wrote: > Hi, > I am completely new to postgres and I have some problems with ODBC > connection. > 1) I am running postgres server in Fedora Linux, and I am planning to > connect server from windows client. > 2) I have installed 64bit version

[SQL] array_agg order by

2012-02-27 Thread jdmorgan
Hello, I am using a array_agg to get a subset of data to use in a query.However, I can't figure out how to get the data returned in the array_agg function to sort with an order by function.Any help would be appreciated.Here is my query as it is now.I am using postgresql 8: select pestproxsha

Re: [SQL] array_agg order by

2012-02-27 Thread Tom Lane
jdmorgan writes: > I am using a array_agg to get a subset of data to use in a > query.However, I can't figure out how to get the data returned in the > array_agg function to sort with an order by function.Any help would be > appreciated.Here is my query as it is now.I am using postgresql 8: We