Re: [GENERAL] Sql problem

2007-10-07 Thread Ben
On Oct 7, 2007, at 9:44 AM, Anton Andreev wrote: Hi, Can you tell me more about Postgresql string functions? Have you had a look at http://www.postgresql.org/docs/8.2/interactive/ functions-string.html? I want to replace a column text "1/2/3/8/" to the corresponding values to these value

[GENERAL] Sql problem

2007-10-07 Thread Anton Andreev
Hi, Can you tell me more about Postgresql string functions? I want to replace a column text "1/2/3/8/" to the corresponding values to these values like "A, B, C, D". Cheers, Anton Andreev ---(end of broadcast)--- TIP 4: Have you searched our l

Re: [GENERAL] SQL problem..

2007-07-03 Thread Bauhaus
thnx ! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] SQL problem..

2007-06-30 Thread Postgres User
Your query won't work because there is no single Price associated with a range of dates. It doesn't make sense. Do you mean to select AVG(Price)? On 6/28/07, Bauhaus <[EMAIL PROTECTED]> wrote: Hello, I'm an Access/SQL novice and I have an sql problem: I have the following table Price: FuelI

Re: [GENERAL] SQL problem..

2007-06-30 Thread Andreas Kretschmer
Bauhaus <[EMAIL PROTECTED]> schrieb: > Hello, > > I'm an Access/SQL novice and I have an sql problem: > > I have the following table Price: > > FuelID PriceDate Price > LPG1/05/2007 0,2 > LPG13/05/2007 0,21 > SPS 2/05/2007 1,1 > SPS 15/05/2007 1,08 > > And I have to make

[GENERAL] SQL problem..

2007-06-29 Thread Bauhaus
Hello, I'm an Access/SQL novice and I have an sql problem: I have the following table Price: FuelID PriceDate Price LPG1/05/2007 0,2 LPG13/05/2007 0,21 SPS 2/05/2007 1,1 SPS 15/05/2007 1,08 And I have to make the following query: FuelID PriceDate_from PriceDate_To Price L