Re: [GENERAL] regexp_replace: LF, CR, or tab

Just for clarity: In the documentation (http://www.postgresql.org/docs/8.4/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP) is mentioned Flag g causes the function to find each match in the string, not only the first one, and return a row for each such match. So in your example it was only

Re: [GENERAL] A history procedure that prevents duplicate entries

Hi Madi, I think you want to use foreign keys which can give you these checks. So add a foreign key to create a link between rad_id of both tables. regards, Bastiaan Madison Kelly wrote: Hi all, I've been using a procedure to make a copy of data in my public schema into a history schema