[SQL] Extract date from week

Hi Looking the e-mail I remembered a question. I saw that "select extract (week from now()::date)" will return the week number of current year. But, how can I convert a week to the first reference date. Ex: select extract(week from '20050105'::date); -- 5 Jan 2005 --Returns-- date_part | 1

Re: [SQL] Returning rows as columns

You're looking for a technique generally referred to as a "pivot table" which is really a non-normalized or aggregate view of relational data You'll find plenty of examples if you Google "pivot table". "Paul" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I'm looking

Re: [SQL] Extract date from week

On 11/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi > Looking the e-mail I remembered a question. > I saw that "select extract (week from now()::date)" will return the > week number > of current year. But, how can I convert a week to the first reference > date. Ex: > select extract(week f

Re: [SQL] can not connect to pg on linux FC4

On Fri, 2005-11-04 at 21:12 -0800, Tai Huynh Phuoc wrote: > Hi, > I use pg 8.03 (come with FC4). I can not connect to pg > because of Ident authentication failed for user "root" > error. pg_hba.conf > host all all 127.0.0.1/32 ident sameuser > > Then I try another way by add adding a row to

Re: [SQL] Design question: Scalability and tens of thousands of

On Thu, 3 Nov 2005 09:58:29 -0800 "zackchandler" <[EMAIL PROTECTED]> threw this fish to the penguins: > I'm designing an application that will allow users to create custom objects > on the application level. A custom object can have zero or more attributes. > Attributes can be one of 5-10 types (e

[SQL] Migrating database from postgresql 7.4.6 to postgresql 8.0.3

Hi, I would like to migrating my database from postgresql 7.4.6 to postgresql 8.0.3. Are there any problem during migrating database? a casting problem or sintax problem, or other problem? Can somebody help me answering this question? Or Does anyone ever try to migrating database from postgresql 7

Re: [SQL] Migrating database from postgresql 7.4.6 to postgresql 8.0.3

am 08.11.2005, um 23:18:35 -0800 mailte Louise Catherine folgendes: > Hi, > I would like to migrating my database from postgresql > 7.4.6 to postgresql 8.0.3. Why not 8.1.0? > Are there any problem during migrating database? a > casting problem or sintax problem, or other problem? I dont know