this?
--
Arnau
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
FUNCTION update_version();
to update the script version and remove the helper functions
*/
SELECT update_version();
DROP FUNCTION check_version();
DROP FUNCTION update_version();
--close the transaction
END;
--
Arnau
---(end of broadcast
it?
Thank you very much
--
Arnau
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Agenda version 1.0.0.0, detected
version %', v_version;
END IF;
END;
$$ LANGUAGE PLPGSQL;
I don't want, if it's possible, to create a function. I just want to
check a value stored in a table and if doesn't match the expected one
then abort the script execution.
--
Arnau
Tom Lane wrote:
Arnau [EMAIL PROTECTED] writes:
I don't want, if it's possible, to create a function.
Unlike Oracle, PG makes a strong distinction between SQL and
programmable languages (including plpgsql). You can't write
plpgsql code without putting it into a function
Arnau wrote:
Tom Lane wrote:
Arnau [EMAIL PROTECTED] writes:
I don't want, if it's possible, to create a function.
Unlike Oracle, PG makes a strong distinction between SQL and
programmable languages (including plpgsql). You can't write
plpgsql code without putting it into a function