I found a workaround: domain type defined as: CREATE DOMAIN currency AS
numeric(16,4);
Thank you!
I'm trying to insert data into Postgres using COPY command. The data
originates from AdventureWorksDW. However, it fails with: "ERROR: invalid
input syntax for type money: "2171.2942" "
Is it possible to import money into Postgres with 4 digits after the dot?
Message-ID: <72746b5e0906152116t13e67918l3eb58b5c304fd...@mail.gmail.com>
Subject: question about meaning of character varying without length
From: Konstantin Izmailov
To: pgsql-gene...@postgresql.com
Content-Type: multipart/alternative; boundary=000e0cd24232e205f2046c
I have tried to send to pgsql-general twice, each time it returns error:
"Relay access denied (state 14)." Will try to post to pgsql-odbc.
Thank you!
On Mon, Jun 15, 2009 at 9:29 PM, Robert Haas wrote:
> On Tue, Jun 16, 2009 at 12:24 AM, Konstantin Izmailov
> wrote:
> >
Hello,
I've found following description: "If character varying is used without
length specifier, the type accepts strings of any size. The latter is a
PostgreSQL extension."
Does this mean that "character varying without length" is equivalent to
"text" type. Are there any differences?
I noticed t
Tom,
this is very helpful - thank you so much!
I had to discover those 'missing' functions one by one, usually after users'
complaints.
Konstantin
On Fri, May 29, 2009 at 11:35 AM, Tom Lane wrote:
> Konstantin Izmailov writes:
> > you know that some Postgres functio
Hi,
I'm not sure that it is related to information_schema but I wanted to let
you know that some Postgres functions are listed in pg_proc while others are
not. For example, all Data Type Formatting function are in pg_proc (to_char,
to_hex, ...). While several of the Date/Time Functions are not ther
for specific Windows apps on
the fly. Thank you!
On Sat, May 23, 2009 at 2:57 PM, Peter Eisentraut wrote:
> On Friday 22 May 2009 18:27:01 Konstantin Izmailov wrote:
> > As we discussed at pgcon2009 there are some changes/fixes necessary in
> > information_schema.columns to allow
As we discussed at pgcon2009 there are some changes/fixes necessary in
information_schema.columns to allow correct work of applications and
services via OLEDB on Windows. Here are some:
1. data_type field contains types names that are not recognized by MS apps.
Code around: rename types on the fl