Re: [ADMIN] [SQL] parsing audit table

2011-08-28 Thread Jan Eskilsson
'2011-08-20' AND '2011-08-25' )); Is what i like to to at all possible to solve ? Thank you in Advance! Jan Eskilsson 2011/8/17 Jaime Casanova > On Tue, Aug 16, 2011 at 4:02 PM, M. D. wrote: > > Hi everyone, > > > > I'm a bit lazy, or actuall

[SQL] hstore and populate_record

2012-02-17 Thread Jan Eskilsson
limited to figure out how? All input is greatly apreciated ! Thank you in advance ! Best Regards Jan Eskilsson -- No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. Please consider the environment before you print this email. (1) The c

[SQL] How to use hstore

2012-06-04 Thread Jan Eskilsson
;);. But i like to to something like this SELECT * FROM populate_record(null::test, (select logfield from logtable where '"col1"=>"456" )); So i wonder how should i do if i have lots of hstore records to convert ? My SQl knowledge is a bi

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 ta