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