Postgresql - Edit function signature
Posted
by drave
on Stack Overflow
See other posts from Stack Overflow
or by drave
Published on 2010-05-11T13:46:57Z
Indexed on
2010/05/11
14:14 UTC
Read the original article
Hit count: 191
POSTGRESQL 8.4.3 - i created a function with this signature
CREATE OR REPLACE FUNCTION logcountforlasthour() RETURNS SETOF record AS
realised i wanted to change it to this
CREATE OR REPLACE FUNCTION logcountforlasthour() RETURNS TABLE(ip bigint, count bigint) record AS
but when i apply that change in the query tool it isnt accepted or rather it is accepted, there is no syntax error, but the text of the function has not been changed. even if i run "DROP FUNCTION logcountforlasthour()" between edits the old syntax comes back
if i edit the body of the function, thats fine, it changes but not the signature
is there something i'm missing
thanks
© Stack Overflow or respective owner