| From: | Dudás József <dj1999(at)freemail(dot)hu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: invalid memory alloc after insert with c trigger function |
| Date: | 2007-06-01 17:31:41 |
| Message-ID: | 466057FD.7030505@freemail.hu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yes! You are right! Now must me find out how to convert char* to numeric
datum and double to numeric datum and numeric datum to double :)
> =?ISO-8859-2?Q?Dud=E1s_J=F3zsef?= <dj1999(at)freemail(dot)hu> writes:
>
>> Just have problem with this conversion from TEXT - double - Datum (
>> NUMERIC ) where in TEXT is a number value forexample now the value is 1.00
>>
>
> NUMERIC? You didn't say anything about NUMERIC before. The code you
> posted thinks it is working with a FLOAT8 datum, which is just about
> entirely unlike NUMERIC. If you are trying to assign that to a table
> column that's declared as NUMERIC, then that type mismatch is exactly
> your problem.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2007-06-01 17:36:40 | Re: multimaster (was: Slightly OT.) |
| Previous Message | Joshua D. Drake | 2007-06-01 17:28:26 | New Live CD needed |