I am designing a new schema from scratch. Which type is more natural to
work with, a timestamp with a timezone or without a timezone? I read
the 7.4 documentation on timezones two or three times but I'm still not
really sure. The fact that the default is without time zone suggests
that without i
Hi All,
Can a query be cast as function: i have a query say like:
select * from tableName where signal>=2000 and signal <=20 and flag>=0;
How can one say in a function "generic tablename"!!
Thanks,
Hrishi
---(end of broadcast)---
TIP 1: subscr
Joshua N Pritikin <[EMAIL PROTECTED]> writes:
> I am designing a new schema from scratch. Which type is more natural to
> work with, a timestamp with a timezone or without a timezone? I read
> the 7.4 documentation on timezones two or three times but I'm still not
> really sure. The fact that th
To do it the way you have there you have to use a set returning function.
See the docs on set returning functions, you also must create a type
that defines the output types.
examples can be found here:
http://www.postgresql.org/docs/8.0/interactive/sql-createtype.html
http://www.postgresql.org/doc
On 05/05/2005 05:46:16 PM, Daniel Browning wrote:
[I posted this recently to ports, but I think this is a more proper
location]
Is anyone working on an 8.0.2 RPM for x86_64 on Red Hat Enterprise
Linux 4? There is a i686 version for RHEL4, and a x86_64 version for
RHEL3,
but no combination of the t
I just read on the Lazarus home page that Zeos (http://www.zeoslib.net)
has been ported to Lazurus.
Lazarus is a Delphi IDE like clone that uses the Free Pascal compiler.
check it out at:
http://www.lazarus.freepascal.org/
Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8
Hi all,
I've been chasing down a bug and from what I have learned it may be
because of how postgreSQL (8.0.2 on Fedora Core 4 test 2) handles
invalid unicode. I've been given some ideas on how to try to catch
invalid unicode but it seems expensive so I am hoping there is a
postgresql way to d
We have developed patches which relaxes the character validation so
that PostgreSQL accepts invalid characters. It works like this:
1) new postgresql.conf item "mbstr_check" added.
2) if mbstr_check = 0 then invalid characters are not accepted
(same as current PostgreSQL behavior). This is the
Thank you, I would!
What versions have you tested the patch against? I am sorry but I am
not too familiar with applying patches against the main program, is
there documentation on how to apply the patch? Is there a way to roll
the patch back/remove it? Would I be able to script th
Tatsuo Ishii wrote:
> Sent: Sunday, May 08, 2005 12:01 PM
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] [GENERAL] Invalid unicode in COPY problem
>
> We have developed patches which relaxes the character
> validation so that Post
John Hansen wrote:
Tatsuo Ishii wrote:
We have developed patches which relaxes the character
validation so that PostgreSQL accepts invalid characters. It
works like this:
That is just plain 100% wrong!!
Under no circumstances should there be invalid data in a database.
And if you're trying to ma
Madison Kelly wrote:
>Under most circumstances I would agree with you completely. In my
> case though I have to decide between risking a loss of a
> user's data or
> attempt to store the file name in some manner that would
> return the same
> name used by the file system.
>
>The user
"John Hansen" <[EMAIL PROTECTED]> writes:
> Tatsuo Ishii wrote:
>> We have developed patches which relaxes the character
>> validation so that PostgreSQL accepts invalid characters.
> That is just plain 100% wrong!!
That was my first reaction too. Why would this be a good idea?
If someone does
> Tatsuo Ishii wrote:
> > Sent: Sunday, May 08, 2005 12:01 PM
> > To: [EMAIL PROTECTED]
> > Cc: pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
> > Subject: Re: [HACKERS] [GENERAL] Invalid unicode in COPY problem
> >
> > We have developed patches which relaxes the character
> > validat
14 matches
Mail list logo
