On Wed, 6 Jan 2010 17:45:31 -0800 (PST)
Yan Cheng Cheok <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to