Re: Views->Create Script + Regular Expressions

On Tue, Aug 23, 2011 at 11:18 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)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 AS
SELECT 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.