Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1icvBh-0001A9-Mm
	for psycopg@arkaria.postgresql.org; Thu, 05 Dec 2019 17:45:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1icvAi-0007ur-5w
	for psycopg@arkaria.postgresql.org; Thu, 05 Dec 2019 17:44:12 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <greatvovan@gmail.com>)
	id 1icvAh-0007uk-Ph
	for psycopg@lists.postgresql.org; Thu, 05 Dec 2019 17:44:11 +0000
Received: from mail-vs1-xe2e.google.com ([2607:f8b0:4864:20::e2e])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <greatvovan@gmail.com>)
	id 1icvAb-0005mX-7R
	for psycopg@lists.postgresql.org; Thu, 05 Dec 2019 17:44:10 +0000
Received: by mail-vs1-xe2e.google.com with SMTP id n27so3018031vsa.0
        for <psycopg@lists.postgresql.org>;
 Thu, 05 Dec 2019 09:44:04 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=e3dhGkAeW+h+IF5mgdeCdwscqgkj2X1VhyPLZc+7uUM=;
        b=tKO10Y6I9kL3TdGsnKLdPVlcsX9iqhnT9n/bcYZS5oIPaQN6pVgW/tU+4Eo4Z6VExq
         DjvA8+nCPyjRCZ63SpTEeZwmxz+ew79mf8KBZq/yNDUtHEf4GJfByJprwQL+J5BMKTzy
         I3F53doxN1tET7hRSKRUu353OYcd7aM5++jR97MsaMrb/Ev74n1DAYMW7AtifYtwxO+s
         l/U3NqTPdjqcYhkuMMJxnnnyFNIKIh7BtMAZgpZunUiiqK8r6JHwJVOenemIm3n7UNMB
         RbKSsLzHPuWMqUohGoPxR+bikZ3lrwry8FhpUhKav/9Ub4a1MYhg/8ZDl27k6is0Wlf6
         ZYzw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=e3dhGkAeW+h+IF5mgdeCdwscqgkj2X1VhyPLZc+7uUM=;
        b=TbomuFtAqtALmmvJQob0dZibJSqRTR9d1LcT8Tu1mSwUTTBLdYOqQNjpYsBlpo1aVv
         jYItWbUBLqmymAdqVzzGwR4iSZu3yFRg70WM0NSY4BUWiEbnyLcl1qb8Sw0w3S6i6NhE
         fVMPovOUVE9aDkJ5Q//LmoQE1CW+cBWn+R/0wtl6BBn17kyMCOuQMWJRAmpKPPHTGhRy
         kMtDi6pStXTrOi2mnW4I8eM7/J+dTByox3gMAwp0MbLzyEAw/Od3+2VDz1IglxMLXahr
         bq1DWlWxdUMglSZwvV1ML88Ge/uwF8059q2MvvpCG6eKKzGLrSSmNcn2MJwcqTmhZF5K
         GNow==
X-Gm-Message-State: APjAAAWMry/Zr5PwiuTLDIqqVTkUCNgoQng9qyRFhCcA5kv+LlFWTC5t
	XfMp+5K6civFC20RcteTToSai1ANrz+p3yIu9/w=
X-Google-Smtp-Source: 
 APXvYqwKx8kYJ+AN4jjmwaDLWXzedu6KkK5U58BTWqlDhnbEmowgXlOEto/Www4+Sdpcvwwzy/nIhITRx3bJEXed5/4=
X-Received: by 2002:a67:3085:: with SMTP id
 w127mr6421079vsw.129.1575567844004;
 Thu, 05 Dec 2019 09:44:04 -0800 (PST)
MIME-Version: 1.0
References: 
 <CAMqTPqntVMh1sk6V2GbwqX8ti7RtN2wQLVS-tYfVuVh8qWc4Tw@mail.gmail.com>
 <VI1PR07MB60293B02275E16B616D95EC6875C0@VI1PR07MB6029.eurprd07.prod.outlook.com>
In-Reply-To: 
 <VI1PR07MB60293B02275E16B616D95EC6875C0@VI1PR07MB6029.eurprd07.prod.outlook.com>
From: Vladimir Ryabtsev <greatvovan@gmail.com>
Date: Thu, 5 Dec 2019 09:43:52 -0800
Message-ID: 
 <CAMqTPqm-DWqKg4q8mJgMz0p9KBR6KDsv0X5gtSiacCMD4kcmog@mail.gmail.com>
Subject: Re: Array of tuples as a parameter, with type casts
To: David Raymond <David.Raymond@tomtom.com>
Cc: "psycopg@lists.postgresql.org" <psycopg@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a958e70598f879dc"
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Precedence: bulk

--000000000000a958e70598f879dc
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

> Isn=E2=80=99t every table its own type? So could you do this?

Wow, you are right! I completely forgot about it!
I even don't need "as t(...)" column list.
Thanks!

--
Regards
Vladimir

--000000000000a958e70598f879dc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">&gt;=C2=A0<span style=3D"font-family:Verd=
ana,sans-serif;font-size:13.3333px">Isn=E2=80=99t every table its own type?=
 So could you do this?<br><br></span><div><span style=3D"font-family:Verdan=
a,sans-serif;font-size:13.3333px">Wow, you are right! I completely forgot a=
bout it!</span></div><div><font face=3D"Verdana, sans-serif"><span style=3D=
"font-size:13.3333px">I even don&#39;t need &quot;as t(...)&quot; column li=
st.</span></font></div><div>Thanks!</div><div><br></div><div>--</div><div>R=
egards</div><div>Vladimir</div><div><br></div></div><div class=3D"gmail_quo=
te"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang=3D"EN-US"><=
div class=3D"gmail-m_9114268222623111880WordSection1"><div>
</div>
</div>
</div>

</blockquote></div></div>

--000000000000a958e70598f879dc--