Re: Views->Create Script + Regular Expressions

On Tue, Aug 23, 2011 at 11:18 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> It would be great if you could provide us a complete example.

Here is a sample view.

--*************
CREATE VIEW TestView AS select cmpnt_name, regexp_matches(cmpnt_name,
E'(^\\d{1,2})-([A-Z]+) *- ?(\\d{3,4})-?([A-Z]*)?')  from component;
--*************

Here what Views->Create Script returns:



--*************
-- View: testview

-- DROP VIEW testview;

CREATE OR REPLACE VIEW testview ASSELECT component.cmpnt_name,
regexp_matches(component.cmpnt_name::text, '(^\\d{1,2})-([A-Z]+) *-
?(\\d{3,4})-?([A-Z]*)?'::text) AS regexp_matches  FROM component;

ALTER TABLE testview OWNER TO rbroersma;
--*************



Notice what happens if I try to execute this script.

WARNING:  nonstandard use of \\ in a string literal
LINE 6: ..._name, regexp_matches(component.cmpnt_name::text, '(^\\d{1,2...
             ^
 
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
Query returned successfully with no result in 157 ms.


-- 
Regards,
Richard Broersma Jr.