Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1opJw8-00064E-9a for pgsql-novice@arkaria.postgresql.org; Mon, 31 Oct 2022 01:50:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1opJw6-0002LB-Ct for pgsql-novice@arkaria.postgresql.org; Mon, 31 Oct 2022 01:49:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1opJw6-0002Kw-1R for pgsql-novice@lists.postgresql.org; Mon, 31 Oct 2022 01:49:58 +0000 Received: from mail-40134.protonmail.ch ([185.70.40.134]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1opJw2-0003UT-Lx for pgsql-novice@lists.postgresql.org; Mon, 31 Oct 2022 01:49:57 +0000 Date: Mon, 31 Oct 2022 01:49:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=protonmail.com; s=protonmail3; t=1667180992; x=1667440192; bh=NZq/bH2DAbJ2ZKuITjU4AoSZuKb3e/G12GliG10k6kI=; h=Date:To:From:Cc:Subject:Message-ID:In-Reply-To:References: Feedback-ID:From:To:Cc:Date:Subject:Reply-To:Feedback-ID: Message-ID:BIMI-Selector; b=G1zFNn/SN86GzvJkqFBfDYjh7EpS84CccXtT8Fqy/9LfAxLoww3ZB8x6OxobxVozd EvNSM+RRHOVPRoThD0ho1LNL/aQ+v2MqYM2EKkJUXXq9dPxohko3iFszO1qyBgVySv 6VQx4Cn+LKxGVRYSNHaYOq7NY7zEIL3J/p2pmunJ/UFpGKNbkXZAdWr0SGDcBy0cjA dy6siHmbhCcsetdACVz/GKC9r8ireRipR05J3xcl3qPu8LnSrOnFIXWTeWewnehU4/ 6lEjF3wZueR/kfkEFCNVqXB4B9fcD+jCbOs4qDLA6IzMDEFec+gkoLJOod15VWxXTf SblduerRkUi8w== To: "David G. Johnston" From: Simon Connah Cc: pgsql-novice Subject: Re: Syntax error Message-ID: In-Reply-To: References: Feedback-ID: 24074989:user:proton MIME-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg=pgp-sha512; boundary="------8314d277ccffc1e622224d12b1f57c8155e9a8c2ee90808c4ef91765e4315e9c"; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------8314d277ccffc1e622224d12b1f57c8155e9a8c2ee90808c4ef91765e4315e9c Content-Type: multipart/mixed;boundary=---------------------01f7f38ef3b6c7f3b1bc9bfc5771bb20 -----------------------01f7f38ef3b6c7f3b1bc9bfc5771bb20 Content-Type: multipart/alternative;boundary=---------------------2445bbbecf38824c833f6feb36580b06 -----------------------2445bbbecf38824c833f6feb36580b06 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain;charset=utf-8 ------- Original Message ------- On Monday, October 31st, 2022 at 01:30, David G. Johnston wrote: > On Sun, Oct 30, 2022 at 6:11 PM Simon Connah 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 talkin= g about. About the only good exception to this is a db-fiddle website wher= e you can actually execute the code being posted. (and you should still pu= t 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 straig= htforward, but I'm stumped. > > = > > If someone could point me in the right direction, I would appreciate i= t. > = > = > You invented some create function syntax the system has no clue what to = do with. There are only two mutually exclusive options for RETURNS, "retty= pe" or the word "TABLE" then a table specification. You seem to somehow wi= sh 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) assum= ption 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. -----------------------2445bbbecf38824c833f6feb36580b06 Content-Type: multipart/related;boundary=---------------------d22e4e5feb344a35d477b54aa2d2b01e -----------------------d22e4e5feb344a35d477b54aa2d2b01e Content-Type: text/html;charset=utf-8 Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6IEFyaWFsOyBmb250LXNpemU6IDE0cHg7Ij48YnI+PC9k aXY+CjxkaXYgY2xhc3M9InByb3Rvbm1haWxfc2lnbmF0dXJlX2Jsb2NrIHByb3Rvbm1haWxfc2ln bmF0dXJlX2Jsb2NrLWVtcHR5IiBzdHlsZT0iZm9udC1mYW1pbHk6IEFyaWFsOyBmb250LXNpemU6 IDE0cHg7Ij4KICAgIDxkaXYgY2xhc3M9InByb3Rvbm1haWxfc2lnbmF0dXJlX2Jsb2NrLXVzZXIg cHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2stZW1wdHkiPgogICAgICAgIAogICAgICAgICAgICA8 L2Rpdj4KICAgIAogICAgICAgICAgICA8ZGl2IGNsYXNzPSJwcm90b25tYWlsX3NpZ25hdHVyZV9i bG9jay1wcm90b24gcHJvdG9ubWFpbF9zaWduYXR1cmVfYmxvY2stZW1wdHkiPgogICAgICAgIAog ICAgICAgICAgICA8L2Rpdj4KPC9kaXY+CjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OiBBcmlhbDsg Zm9udC1zaXplOiAxNHB4OyI+PGJyPjwvZGl2PjxkaXYgY2xhc3M9InByb3Rvbm1haWxfcXVvdGUi PgogICAgICAgIC0tLS0tLS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0tLS0tPGJyPgogICAgICAgIE9u IE1vbmRheSwgT2N0b2JlciAzMXN0LCAyMDIyIGF0IDAxOjMwLCBEYXZpZCBHLiBKb2huc3RvbiAm bHQ7ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb20mZ3Q7IHdyb3RlOjxicj48YnI+CiAgICAgICAg PGJsb2NrcXVvdGUgY2xhc3M9InByb3Rvbm1haWxfcXVvdGUiIHR5cGU9ImNpdGUiPgogICAgICAg ICAgICA8ZGl2IGRpcj0ibHRyIj48ZGl2IGRpcj0ibHRyIj48ZGl2IHN0eWxlPSJmb250LWZhbWls eTphcmlhbCxoZWx2ZXRpY2Esc2Fucy1zZXJpZiIgY2xhc3M9ImdtYWlsX2RlZmF1bHQiPjxzcGFu IHN0eWxlPSJmb250LWZhbWlseTpBcmlhbCxIZWx2ZXRpY2Esc2Fucy1zZXJpZiI+T24gU3VuLCBP Y3QgMzAsIDIwMjIgYXQgNjoxMSBQTSBTaW1vbiBDb25uYWggJmx0OzxhIGhyZWY9Im1haWx0bzpz aW1vbi5uLmNvbm5haEBwcm90b25tYWlsLmNvbSIgcmVsPSJub3JlZmVycmVyIG5vZm9sbG93IG5v b3BlbmVyIiB0YXJnZXQ9Il9ibGFuayI+c2ltb24ubi5jb25uYWhAcHJvdG9ubWFpbC5jb208L2E+ Jmd0OyB3cm90ZTo8L3NwYW4+PGJyPjwvZGl2PjwvZGl2PjxkaXYgY2xhc3M9ImdtYWlsX3F1b3Rl Ij48YmxvY2txdW90ZSBzdHlsZT0ibWFyZ2luOjBweCAwcHggMHB4IDAuOGV4O2JvcmRlci1sZWZ0 OjFweCBzb2xpZCByZ2IoMjA0LDIwNCwyMDQpO3BhZGRpbmctbGVmdDoxZXgiIGNsYXNzPSJnbWFp bF9xdW90ZSI+SGkuPGJyPgo8YnI+ClRoZSBTUUwgZmlsZSBhbmQgZXJyb3IgY2FuIGJlIGZvdW5k IGhlcmU6PGJyPgo8YnI+CjxhIHRhcmdldD0iX2JsYW5rIiByZWw9Im5vcmVmZXJyZXIgbm9mb2xs b3cgbm9vcGVuZXIiIGhyZWY9Imh0dHBzOi8vZ2lzdC5naXRodWIuY29tL3NpbW9uY29ubmFoL2Vk ZGVlZDI2NjE5NDljOTBmMzRmZjkxYTNkYjMxOTFiIj5odHRwczovL2dpc3QuZ2l0aHViLmNvbS9z aW1vbmNvbm5haC9lZGRlZWQyNjYxOTQ5YzkwZjM0ZmY5MWEzZGIzMTkxYjwvYT48L2Jsb2NrcXVv dGU+PGRpdj48YnI+PC9kaXY+PGRpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTphcmlhbCxoZWx2 ZXRpY2Esc2Fucy1zZXJpZiIgY2xhc3M9ImdtYWlsX2RlZmF1bHQiPkZvciBzb21ldGhpbmcgdGhh dCB0cml2aWFsIGp1c3QgaW5jbHVkZSBpdCBpbiB0aGUgYm9keSBvZiB0aGUgZW1haWwsIGRvbid0 IG1ha2UgcGVvcGxlIGdvIG91dCB0byBhIHN0YXRpYyBmb3JlaWduIHNpdGUgdG8ga25vdyB3aGF0 IHlvdSBhcmUgdGFsa2luZyBhYm91dC4gIEFib3V0IHRoZSBvbmx5IGdvb2QgZXhjZXB0aW9uIHRv IHRoaXMgaXMgYSBkYi1maWRkbGUgd2Vic2l0ZSB3aGVyZSB5b3UgY2FuIGFjdHVhbGx5IGV4ZWN1 dGUgdGhlIGNvZGUgYmVpbmcgcG9zdGVkLiAoYW5kIHlvdSBzaG91bGQgc3RpbGwgcHV0IHRoZSBt YWluIHBhcnRzIG9mIHRoZSBxdWVzdGlvbiBpbiB0aGUgZW1haWwgZXZlbiB0aGVuKS48L2Rpdj48 L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTphcmlhbCxoZWx2ZXRpY2Esc2Fucy1zZXJpZiIg Y2xhc3M9ImdtYWlsX2RlZmF1bHQiPjxicj48L2Rpdj48YmxvY2txdW90ZSBzdHlsZT0ibWFyZ2lu OjBweCAwcHggMHB4IDAuOGV4O2JvcmRlci1sZWZ0OjFweCBzb2xpZCByZ2IoMjA0LDIwNCwyMDQp O3BhZGRpbmctbGVmdDoxZXgiIGNsYXNzPSJnbWFpbF9xdW90ZSI+PGJyPgo8YnI+CkknbSBub3Qg c3VyZSB3aHkgSSdtIGdldHRpbmcgdGhlIGVycm9yIG1lc3NhZ2UuIEl0IGlzIHNvbWV0aGluZyBz dHJhaWdodGZvcndhcmQsIGJ1dCBJJ20gc3R1bXBlZC48YnI+Cjxicj4KSWYgc29tZW9uZSBjb3Vs ZCBwb2ludCBtZSBpbiB0aGUgcmlnaHQgZGlyZWN0aW9uLCBJIHdvdWxkIGFwcHJlY2lhdGUgaXQu PGJyPjxicj48L2Jsb2NrcXVvdGU+PGRpdj48YnI+PC9kaXY+PGRpdiBzdHlsZT0iZm9udC1mYW1p bHk6YXJpYWwsaGVsdmV0aWNhLHNhbnMtc2VyaWYiIGNsYXNzPSJnbWFpbF9kZWZhdWx0Ij5Zb3Ug aW52ZW50ZWQgc29tZSBjcmVhdGUgZnVuY3Rpb24gc3ludGF4IHRoZSBzeXN0ZW0gaGFzIG5vIGNs dWUgd2hhdCB0byBkbyB3aXRoLiAgVGhlcmUgYXJlIG9ubHkgdHdvIG11dHVhbGx5IGV4Y2x1c2l2 ZSBvcHRpb25zIGZvciBSRVRVUk5TLCAicmV0dHlwZSIgb3IgdGhlIHdvcmQgIlRBQkxFIiB0aGVu IGEgdGFibGUgc3BlY2lmaWNhdGlvbi4gIFlvdSBzZWVtIHRvIHNvbWVob3cgd2lzaCB0byBjb21i aW5lIHRoZW0sIGRyb3BwaW5nIHRoZSB3b3JkIFRBQkxFLjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQt ZmFtaWx5OmFyaWFsLGhlbHZldGljYSxzYW5zLXNlcmlmIiBjbGFzcz0iZ21haWxfZGVmYXVsdCI+ PGJyPjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFsLGhlbHZldGljYSxzYW5zLXNl cmlmIiBjbGFzcz0iZ21haWxfZGVmYXVsdCI+PGEgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvZG9jcy9jdXJyZW50L3NxbC1jcmVhdGVmdW5jdGlvbi5odG1sIiByZWw9Im5vcmVmZXJy ZXIgbm9mb2xsb3cgbm9vcGVuZXIiIHRhcmdldD0iX2JsYW5rIj5odHRwczovL3d3dy5wb3N0Z3Jl c3FsLm9yZy9kb2NzL2N1cnJlbnQvc3FsLWNyZWF0ZWZ1bmN0aW9uLmh0bWw8L2E+PGJyPjwvZGl2 PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFsLGhlbHZldGljYSxzYW5zLXNlcmlmIiBjbGFz cz0iZ21haWxfZGVmYXVsdCI+PGJyPjwvZGl2PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OmFyaWFs LGhlbHZldGljYSxzYW5zLXNlcmlmIiBjbGFzcz0iZ21haWxfZGVmYXVsdCI+RGF2aWQgSi48L2Rp dj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTphcmlhbCxoZWx2ZXRpY2Esc2Fucy1zZXJpZiIgY2xh c3M9ImdtYWlsX2RlZmF1bHQiPjxicj48L2Rpdj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTphcmlh bCxoZWx2ZXRpY2Esc2Fucy1zZXJpZiIgY2xhc3M9ImdtYWlsX2RlZmF1bHQiPjwvZGl2PjwvZGl2 PjwvZGl2PgoKICAgICAgICA8L2Jsb2NrcXVvdGU+PC9kaXY+PGRpdiBjbGFzcz0icHJvdG9ubWFp bF9xdW90ZSIgc3R5bGU9ImZvbnQtZmFtaWx5OiBBcmlhbDsgZm9udC1zaXplOiAxNHB4OyBjb2xv cjogcmdiKDAsIDAsIDApOyI+TXkgYXBvbG9naWVzLiBJIHdvbid0IHVzZSBHaXRIdWIgYW55bW9y ZS4gSSBqdXN0IG1hZGUgYW4gKGluY29ycmVjdCkgYXNzdW1wdGlvbiB0aGF0IG1vc3QgcGVvcGxl IHdvdWxkIGZpbmQgaXQgZWFzaWVyIHRvIHVzZS48L2Rpdj48ZGl2IGNsYXNzPSJwcm90b25tYWls X3F1b3RlIiBzdHlsZT0iZm9udC1mYW1pbHk6IEFyaWFsOyBmb250LXNpemU6IDE0cHg7IGNvbG9y OiByZ2IoMCwgMCwgMCk7Ij48YnI+PC9kaXY+PGRpdiBjbGFzcz0icHJvdG9ubWFpbF9xdW90ZSIg c3R5bGU9ImZvbnQtZmFtaWx5OiBBcmlhbDsgZm9udC1zaXplOiAxNHB4OyBjb2xvcjogcmdiKDAs IDAsIDApOyI+WWVzLCBJIHdhcyBwbGF5aW5nIGFyb3VuZCB3aXRoIGl0IGZvciBhIGJpdCBidXQg Z290IHN0dWNrIGFuZCBwcm9iYWJseSBkaWQgc29tZXRoaW5nIHN0dXBpZC48L2Rpdj48ZGl2IGNs YXNzPSJwcm90b25tYWlsX3F1b3RlIiBzdHlsZT0iZm9udC1mYW1pbHk6IEFyaWFsOyBmb250LXNp emU6IDE0cHg7IGNvbG9yOiByZ2IoMCwgMCwgMCk7Ij48YnI+PC9kaXY+PGRpdiBjbGFzcz0icHJv dG9ubWFpbF9xdW90ZSIgc3R5bGU9ImZvbnQtZmFtaWx5OiBBcmlhbDsgZm9udC1zaXplOiAxNHB4 OyBjb2xvcjogcmdiKDAsIDAsIDApOyI+U2ltb24uPC9kaXY+PGRpdiBjbGFzcz0icHJvdG9ubWFp bF9xdW90ZSI+CiAgICA8L2Rpdj4= -----------------------d22e4e5feb344a35d477b54aa2d2b01e-- -----------------------2445bbbecf38824c833f6feb36580b06-- -----------------------01f7f38ef3b6c7f3b1bc9bfc5771bb20-- --------8314d277ccffc1e622224d12b1f57c8155e9a8c2ee90808c4ef91765e4315e9c Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: ProtonMail wnUEARYKAAYFAmNfKbAAIQkQWu8oLvi1rqUWIQRc5gX26oVGfjzXltha7ygu +LWupX6nAQCTYtJfnbFD9uQUV2ArSZgzdWjRN0N3P9x8FCcPjT3PZwEAlqCO n5nuyQui11t1wFSLBiskYyQqNF68NQpzc5HIoQs= =0q+1 -----END PGP SIGNATURE----- --------8314d277ccffc1e622224d12b1f57c8155e9a8c2ee90808c4ef91765e4315e9c--