Re: back slash separated values - Mailing list pgsql-general

From William ZHANG
Subject Re: back slash separated values
Date
Msg-id dvrai6$2ugi$1@news.hub.org
Whole thread Raw
In response to back slash separated values  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
What's the version of pgsql?

postgres=# show server_version;
 server_version
----------------
 8.1.0
(1 row)

postgres=# CREATE OR REPLACE FUNCTION foo (v_s1 varchar, v_s2 varchar)
postgres-# RETURNS varchar AS $$
postgres$# BEGIN
postgres$#     RETURN v_s1 || '\\' || v_s2;
postgres$# END;
postgres$# $$ LANGUAGE plpgsql;
CREATE FUNCTION

postgres=# SELECT foo ('pgsql', 'hackers');
      foo
---------------
 pgsql\hackers
(1 row)

Regards,
William ZHANG



pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Enforcing serial uniqueness?
Next
From: "William ZHANG"
Date:
Subject: Re: partial resultset in java