Wednesday, December 9, 2009

Force PostgreSQL to raise 'no_data_found' and 'too_many_rows' exceptions while using 'Select into'

    Using “Strict” keyword before the target variable, we may force the Postgres to do the constraint against the result-set like,


    SELECT INTO STRICT x y from tbl;




     Ref: http://www.postgresql.org/docs/current/static/plpgsql-statements.html



No comments:

Post a Comment