Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Fri, Feb 11, 2005 at 03:37:01PM -0500, Tom Lane wrote:
>> [ thinks about that for awhile... ] Oh, I see. The reason this appears
>> to work is that plpgsql compiles a separate version of the function for
>> each actual parameter datatype that is used
On Fri, Feb 11, 2005 at 03:37:01PM -0500, Tom Lane wrote:
> [ thinks about that for awhile... ] Oh, I see. The reason this appears
> to work is that plpgsql compiles a separate version of the function for
> each actual parameter datatype that is used in a given session. So in
> your example, yo
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Fri, Feb 11, 2005 at 02:32:31PM -0500, Tom Lane wrote:
>> There are some limited cases you could handle in plpgsql using the
>> polymorphic-functions stuff (ie, ANYELEMENT not ANY) but it still has
>> no concept of a run-time type test.
> Eh? What am
On Fri, Feb 11, 2005 at 02:32:31PM -0500, Tom Lane wrote:
> There are some limited cases you could handle in plpgsql using the
> polymorphic-functions stuff (ie, ANYELEMENT not ANY) but it still has
> no concept of a run-time type test.
Eh? What am I misunderstanding then? The following done in
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Fri, Feb 11, 2005 at 08:40:53PM +, NosyMan wrote:
>> I want something like this:
>>
>> CREATE OR REPLACE FUNCTION myfunction(_param ANY) RETURNS INTEGER AS $$
> PostgreSQL has an undocumented IS OF construct:
... which won't help since IS OF is a
On Fri, Feb 11, 2005 at 08:40:53PM +, NosyMan wrote:
>
> How can I test the type of a parameter passed to a function via ANY data
> type?
> I want something like this:
>
> CREATE OR REPLACE FUNCTION myfunction(_param ANY) RETURNS INTEGER AS $$
> BEGIN
> IF "_param IS OF
Hi there,
How can I test the type of a parameter passed to a function via ANY data type?
I want something like this:
CREATE OR REPLACE FUNCTION myfunction(_param ANY) RETURNS INTEGER AS $$
BEGIN
IF "_param IS OF INTEGER TYPE" THEN
-- do something w
test
--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
begin:vcard
fn:Joshu
just a test
___
Yahoo! Mail - Agora com 250MB de espaço gratuito. Abra
uma conta agora! http://br.info.mail.yahoo.com/
---(end of broadcast)---
TIP 5: Have you
The list is either down or very quiet ?
G
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
This is a test -- please ignore
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
I don't seem to see my messages in the digest. Is this a mail setting? I thought that
only blockable in the single message mode.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comma
Sorry to waste bandwidth but I've never seen a day with no messages.
G
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Gunasekaran Balakrishnan wrote:
> Hi,
>
> I see that one of the bug fixes in 7.4.3 is:
>
> "Fix temporary memory leak when using non-hashed aggregates (Tom)"
>
> I am still using 7.4.2, and want to find out if I need to upgrade to 7.4.3.
>
> I did not quite understand the bug, or find a wa
Hi,
I see that one of the bug fixes in 7.4.3 is:
"Fix temporary memory leak when using non-hashed aggregates (Tom)"
I am still using 7.4.2, and want to find out if I need to upgrade to 7.4.3.
I did not quite understand the bug, or find a way to re-produce this in the
mailist archives.
None of my mail messages seem to be getting through to the list, so this
is a test
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
test
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
How can I test that a text variable has a value that represents a valid data
type, other than writing something like: variable IN ('integer', 'text',
'float'...)?
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postg
Sorry if it double posts, the first one seems to have vanished...
How can I test that a text variable has a value that represents a valid data
type, other than writing something like: variable IN ('integer', 'text',
'float'...)?
---(end of broadcast)-
Sorry for test post.
lt ss 9/26/2001
»úÃÜ ÉîÛÚÊзçÁÖ»ð
Hi,
Here is a snapshot of the code I'm fiddling with at the moment which
actually tracks how much time is spent executing which parts of the query
plan. It still has some issues but it has restored my faith in Postgres'
estimation system. It's within an order of magnitude in the tests I've done
a
Yeah,
DROP TABLE employees
CREATE TABLE employees
;-)
Craig
-Original Message-
From: Soma Interesting [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 1:40 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Test for existence of Table
Can I test for an existing table before
Can I test for an existing table before issuing the "CREATE TABLE" command?
IF EXISTS employees{
DROP TABLE employees
}
CREATE TABLE employees
Can you provide an example of this. I couldn't find this in the manual or
Bruce's book - did I not look hard enough ? :)
- -
ignore me
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Hey, it worked!
--
Scott Holdren
[EMAIL PROTECTED]
prova
This is a
test
This is the test message only
=
Jeff MacDonald // Hub.org Networking Services // PostgreSQL INC
[EMAIL PROTECTED]// [EMAIL PROTECTED] // [EMAIL PROTECTED]
http://hub.org/~jeff // http://hub.org // http:/
What are the limits of the TEXT data type in PostgreSQL 6.3.2? I have some
fairly large memos currently in msaccess that I'd like to pull into
postgres (I'm going to convert the entire database into postgres). Some of
our existing memo fields literally have a few pages (ok, generic term, but
101 - 131 of 131 matches
Mail list logo