[GENERAL] integer only sposix/regex

I'm trying to search phone numbers for digits. Unfortunately, the validation has been sloppy and the numbers are not just numbers, they also have dashes and probably other stuff. I would like the search to ignore anything but integers WHERE (a.phone1 ~* '.*626.*' OR a.phone2 ~* '.*626.*' OR a.phon

[GENERAL] interval is ignored

SELECT INTERVAL '1' MONTH = 00:00:00 Therefore now=onemonthago SELECT NOW(),NOW()- INTERVAL '1' MONTH as onemonthago How do I get the timestamp for one month ago? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.or

Re: [GENERAL] interval is ignored

On Jun 11, 10:14 am, rodeored wrote: > SELECT INTERVAL '1' MONTH = 00:00:00 >  Therefore now=onemonthago > SELECT NOW(),NOW()- INTERVAL '1' MONTH as onemonthago > > How do I get the timestamp for one month ago? Never mind, its SELECT NOW(),NOW()- INTERVAL &#x