On Wed, 6 Jan 2010 17:45:31 -0800 (PST)
Yan Cheng Cheok <ycch...@yahoo.com> wrote:

> situation, I will be only interested in 1 "YanChengCHEOK".


>     SELECT measurement_type_id INTO _measurement_type_id FROM
> measurement_type WHERE measurement_type_name='YanChengCHEOK';

LIMIT 1

Is that what you were looking for?

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to