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