public inbox for [email protected]
help / color / mirror / Atom feedFrom: Simon Connah <[email protected]>
To: David G. Johnston <[email protected]>
Cc: pgsql-novice <[email protected]>
Subject: Re: Syntax error
Date: Mon, 31 Oct 2022 01:49:47 +0000
Message-ID: <Gi0Ga-IdqRfElHWAdHZH-l58OO8SPY4FgTXMmbMEH29B0FT46uLj8o6eLcn6r2MEAxb3OhzlfsW3bAz_OJ_XD5ZjF4B90aDiW39PMIQVXF8=@protonmail.com> (raw)
In-Reply-To: <CAKFQuwZLZOewC2piOvYEhu5uprAQmE4sg5nOnsDW0jc3fuZJ_g@mail.gmail.com>
References: <Q_H04Jq5Cwt5uLaj6yoBZatqznq8ArDL5BMPchLefhc9NQ7qEASdYdXXzIDdGUKPXFUJtyhy22gpeTq2jlZNVR0nVYNMocjJlLF55yidbqY=@protonmail.com>
<CAKFQuwZLZOewC2piOvYEhu5uprAQmE4sg5nOnsDW0jc3fuZJ_g@mail.gmail.com>
------- Original Message -------
On Monday, October 31st, 2022 at 01:30, David G. Johnston <[email protected]> wrote:
> On Sun, Oct 30, 2022 at 6:11 PM Simon Connah <[email protected]> wrote:
>
> > Hi.
> >
> > The SQL file and error can be found here:
> >
> > https://gist.github.com/simonconnah/eddeed2661949c90f34ff91a3db3191b
>
>
> For something that trivial just include it in the body of the email, don't make people go out to a static foreign site to know what you are talking about. About the only good exception to this is a db-fiddle website where you can actually execute the code being posted. (and you should still put the main parts of the question in the email even then).
>
>
> >
> >
> > I'm not sure why I'm getting the error message. It is something straightforward, but I'm stumped.
> >
> > If someone could point me in the right direction, I would appreciate it.
>
>
> You invented some create function syntax the system has no clue what to do with. There are only two mutually exclusive options for RETURNS, "rettype" or the word "TABLE" then a table specification. You seem to somehow wish to combine them, dropping the word TABLE.
>
> https://www.postgresql.org/docs/current/sql-createfunction.html
>
> David J.
>
My apologies. I won't use GitHub anymore. I just made an (incorrect) assumption that most people would find it easier to use.
Yes, I was playing around with it for a bit but got stuck and probably did something stupid.
Simon.
Attachments:
[application/pgp-signature] signature.asc (249B, ../Gi0Ga-IdqRfElHWAdHZH-l58OO8SPY4FgTXMmbMEH29B0FT46uLj8o6eLcn6r2MEAxb3OhzlfsW3bAz_OJ_XD5ZjF4B90aDiW39PMIQVXF8=@protonmail.com/3-signature.asc)
download
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Syntax error
In-Reply-To: <Gi0Ga-IdqRfElHWAdHZH-l58OO8SPY4FgTXMmbMEH29B0FT46uLj8o6eLcn6r2MEAxb3OhzlfsW3bAz_OJ_XD5ZjF4B90aDiW39PMIQVXF8=@protonmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox