On Wednesday 16 December 2009 5:05:19 pm Justin Bailey wrote:
> Greetings! I am trying to avoid the old problem of inserting a 40
> character string into a 20 character field. However, I'd like to avoid
> hard-coding the acceptable length (20). Is there a way to say "cast to
> the same type as a gi
On Thu, Dec 17, 2009 at 10:24:28AM -0500, Tom Lane wrote:
> Justin Bailey writes:
> > If s was automatically truncated, the insert would succeed, but it
> > fails with a "value too long" error.
>
> Oh, I thought the failure was the behavior you wanted. There's
> no automatic truncation here ---
Justin Bailey writes:
> On Wed, Dec 16, 2009 at 7:20 PM, Tom Lane wrote:
>> Really? Works for me, in everything back to 7.3.
> If s was automatically truncated, the insert would succeed, but it
> fails with a "value too long" error.
Oh, I thought the failure was the behavior you wanted. There
On Wed, Dec 16, 2009 at 7:20 PM, Tom Lane wrote:
> Really? Works for me, in everything back to 7.3.
>
I must be missing something, because this function fails:
CREATE OR REPLACE FUNCTION insertShort()
RETURNS VOID AS
$BODY$
DECLARE
s Short.shortCol%TYPE;
BEGIN
SELECT longCol I
Justin Bailey writes:
> I have tried using the PL/PGSQL
> feature where types can be "copied" in a declaration:
> DECLARE
> myVal Short.shortCol%TYPE;
> But I can still put values which are too long into that variable, so
> it doesn't help me.
Really? Works for me, in everything back to
Greetings! I am trying to avoid the old problem of inserting a 40
character string into a 20 character field. However, I'd like to avoid
hard-coding the acceptable length (20). Is there a way to say "cast to
the same type as a given column"? E.g., if I have tables Long and
Short:
CREATE TABLE Lon
Greetings! I am trying to avoid the old problem of inserting a 40
character string into a 20 character field. However, I'd like to avoid
hard-coding the acceptable length (20). Is there a way to say "cast to
the same type as a given column"? E.g., if I have tables Long and
Short:
CREATE TABLE Lo