Cast Const Integer to Bigint in Postgres

Question

I'm getting the below error while running the below script. My goal is to create a function in Postgres to return 1 as a bigint. Help please!

hashtagpostgresnoobie

ERROR: function result type must be bigint because of OUT parameters

CREATE OR REPLACE FUNCTION GetNumberOne(
    OUT numberone bigint)
  RETURNS SETOF record AS
$BODY$

    SELECT CAST(1 AS BIGINT) AS "NUMBERONE";

$BODY$
  LANGUAGE sql VOLATILE;

Timur Sadykov · Accepted Answer · 2012-03-20 20:15:16Z

22

You've suddenly encountered the feature ) Record needs two and more fields. So when you have only one out variable, then result must be scalar.

So, you can simply do what compilers ask )

CREATE OR REPLACE FUNCTION GetNumberOne(
        OUT numberone bigint)
      RETURNS bigint AS
    $BODY$

        SELECT CAST(1 AS BIGINT) AS "NUMBERONE";

    $BODY$
      LANGUAGE sql VOLATILE;

plpgsql example:

CREATE OR REPLACE FUNCTION NumberOne()
      RETURNS bigint AS
    $BODY$
      DECLARE num bigint;
      BEGIN
        num := 1;
        RETURN num;
      END
    $BODY$
      LANGUAGE plpgsql VOLATILE;
      select * from NumberOne()

edited Mar 20, 2012 at 20:15

answered Mar 20, 2012 at 19:21

Timur Sadykov

11.6k7 gold badges35 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nick Vaccaro Over a year ago

I apologize for my slowness, but could you please be more specific? I had a hard time following that. I've been using Postgres for all of about 10 hours now. :/

Timur Sadykov Over a year ago

I'll provide exact snippet after lunch )

Timur Sadykov Over a year ago

It turned out to be simpler. Take a look.

Nick Vaccaro Over a year ago

Holy fantastic answers, Batman! I'd upvote more than once if I could.

Collectives™ on Stack Overflow

Cast Const Integer to Bigint in Postgres

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related