Re: [SQL] please help me on regular expression
Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems. — Jamie Zawinski 3 feb 2010 kl. 21.32 skrev Tena Sakai: > Thank you, Dirk. > > Regards, > > Tena Sakai > tsa...@gallo.ucsf.edu > > > On 2/3/10 11:43 AM, "Dirk Jagdmann" wrote: > >> Be careful when working with backslashes and regular expressions for >> the proper (double) escaping! >> >> # select '70a5' ~ e'\\d+\.\\d+'; >> ?column? >> -- >> t >> (1 row) >> >> # select '70a5' ~ e'\\d+\\.\\d+'; >> ?column? >> -- >> f >> (1 row) >> >> # select '70.5' ~ e'\\d+\\.\\d+'; >> ?column? >> -- >> t > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
[SQL] internal format of timstamp?
Hi, I am trying to recover a lot of deleted rows from a database ( pg 8.2.3 ) , not my database, I promise….. When using the tool pgfsck I get good results, but timestamp is not implemented. When trying to export as int8 i get fx. 4735129360236469258 representing december 29, 2011, 16:30 But how should I do the conversion from the numeric value to the actual timestamp ? Regards, Lars. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
