·

339

· andersbrownwort

SQL functions that SELECT records explicitly are fairly straightforward:

CREATE OR REPLACE FUNCTION name_for_email(query varchar, OUT email varchar)
 RETURNS SETOF record
 AS
$$
 SELECT name 
 FROM customers 
 WHERE email = 1ドル;
$$
 LANGUAGE 'sql';

and then SELECT like this:

SELECT * from name_for_email('joe@test.com');

SELECTing records that match a pattern, however, can be done like this:

CREATE OR REPLACE FUNCTION name_for_email(query varchar, OUT email varchar)
 RETURNS SETOF record
 AS
$$
 SELECT name 
 FROM customers
 WHERE email LIKE 1ドル;
$$
 LANGUAGE 'sql';

and then SELECT by passing the pattern:

SELECT * from name_for_email('%@test.com');

Related protips

Have a fresh tip? Share with Coderwall community!

Post

Post a tip

Sponsored by

#native_company#

#native_desc#

#native_cta#

Post a job for only 299ドル

Sponsored by #native_company# — Learn More