Re: [SQL] How to use hstore

2012-06-04 Thread Jan Eskilsson
Hi Sergey Thats exacly what i was looking for, thanks a million ! Best regards Jan Eskilsson 2012/6/5 Sergey Konoplev : > On Mon, Jun 4, 2012 at 4:08 PM, Jan Eskilsson wrote: >> My problem is that i would like to be able to retrieve a group of >> records from the hstore table and present them

Re: [SQL] How to use hstore

2012-06-04 Thread Sergey Konoplev
On Mon, Jun 4, 2012 at 4:08 PM, Jan Eskilsson wrote: > My problem is that i would like to be able to retrieve a group of > records from the hstore table and present them in a grid so I would > like to convert the hstore records back to the original table format. > In the manual i found an example

[SQL] How to use hstore

2012-06-04 Thread Jan Eskilsson
Hi all I log data in a table using a hstore field. My problem is that i would like to be able to retrieve a group of records from the hstore table and present them in a grid so I would like to convert the hstore records back to the original table format. In the manual i found an example how to c

Re: [SQL] Job control in sql

2012-06-04 Thread lewbloch
Sorry about the earlier unfinished post - premature click. Svenne Krap wrote: > Ireneusz Pluta wrote: >> Svenne Krap pisze: > >> I am building a system, where we have jobs that run at different > >> times (and takes widely different lengths of time). > >> > >> Basically I have a jobs table: > >> >

Re: [SQL] Job control in sql

2012-06-04 Thread lewbloch
Svenne Krap wrote: > On 29-05-2012 12:32, Ireneusz Pluta wrote: > > W dniu 2012-05-25 10:28, Svenne Krap pisze: > >> Hi. > >> > >> I am building a system, where we have jobs that run at different > >> times (and takes widely different lengths of time). > >> > >> Basically I have a jobs table: > >>

Re: [SQL] Select row cells as new columns

2012-06-04 Thread lewbloch
danycxxx wrote: > Yes, I've looked at it, but id doesn't create the desired output. After more > research I've found that I my design is similar to Entity, Attribute and > Value(EAV) design and I think I have to redesign. Any suggestion regarding > EAV? Is there any other approach? EAV is controve