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: 195

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

Related posts about postgresql

Related posts about user