On 24/lug/08, at 23:15, Richard Broersma wrote:
On Thu, Jul 24, 2008 at 12:35 PM, Giorgio Valoti
<[EMAIL PROTECTED]> wrote:
Um - there is no default value for a function.
Without this "feature" you have to overload
the function arguments.
You could pass a casted null to the function. T
On Thu, Jul 24, 2008 at 12:35 PM, Giorgio Valoti <[EMAIL PROTECTED]> wrote:
>> Um - there is no default value for a function.
>
> Without this "feature" you have to overload
> the function arguments.
You could pass a casted null to the function. The would eliminate
function overloading. Then in
On 24/lug/08, at 12:42, Richard Huxton wrote:
Giorgio Valoti wrote:
postgres=# insert into f(a,b) values(default, default) returning *;
It seems that you can’t use the same syntax with function calls:
select function(default,default);
gives a syntax error. Is it expected?
Um - there is no d
Giorgio Valoti wrote:
postgres=# insert into f(a,b) values(default, default) returning *;
It seems that you can’t use the same syntax with function calls:
select function(default,default);
gives a syntax error. Is it expected?
Um - there is no default value for a function.
--
Richard Hux
On 23/lug/08, at 11:28, Pavel Stehule wrote:
Hello
2008/7/23 Maximilian Tyrtania <[EMAIL PROTECTED]>:
Hi there, just a quickie: Is there a way to select all default
values of a
given table? Something like "Select Default values from sometable" ?
Unfortunately this syntax doesn't seem to be
On Wed, Jul 23, 2008 at 3:57 AM, Maximilian Tyrtania
<[EMAIL PROTECTED]> wrote:
> Hi,
>
>> am Wed, dem 23.07.2008, um 10:32:58 +0200 mailte Maximilian Tyrtania
>> folgendes:
>>> Hi there, just a quickie: Is there a way to select all default values of a
>>> given table? Something like "Select Defau
Pavel,
fantastic, that's exactly what I wanted, thank you very much!
Maximilian Tyrtania
> Von: Pavel Stehule <[EMAIL PROTECTED]>
>> Okay, here is one final (i hope) obstacle. My db has >200 tables and I'd
>> love to be able to write some function that would just take a tablename and
>> return
2008/7/23 Maximilian Tyrtania <[EMAIL PROTECTED]>:
> Hi,
>
>> begin
>> insert ...
>> rollback;
>>
>> it's not best solution, but it just works.
>
> Ah, yes, of course, haven't thought of that.
>
> Okay, here is one final (i hope) obstacle. My db has >200 tables and I'd
> love to be able to write
On Wed, Jul 23, 2008 at 12:35:08PM +0200, Maximilian Tyrtania wrote:
> With your way (insert into f(a,b) values(default, default) returning *) i
> need to know everything about the given table.
>
> Hmm. Any ideas?
Do look at the information schema.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.n
Hi,
> begin
> insert ...
> rollback;
>
> it's not best solution, but it just works.
Ah, yes, of course, haven't thought of that.
Okay, here is one final (i hope) obstacle. My db has >200 tables and I'd
love to be able to write some function that would just take a tablename and
return the de
2008/7/23 Maximilian Tyrtania <[EMAIL PROTECTED]>:
> Hi again,
>
>>> Hi there, just a quickie: Is there a way to select all default values of a
>>> given table? Something like "Select Default values from sometable" ?
>
>> it's not possible directly, you can find expressions used as default
>> in sy
Hi,
> am Wed, dem 23.07.2008, um 10:32:58 +0200 mailte Maximilian Tyrtania
> folgendes:
>> Hi there, just a quickie: Is there a way to select all default values of a
>> given table? Something like "Select Default values from sometable" ?
>
> test=# create table t_with_defaults( s1 int default 1
Hi again,
>> Hi there, just a quickie: Is there a way to select all default values of a
>> given table? Something like "Select Default values from sometable" ?
> it's not possible directly, you can find expressions used as default
> in system tables or
> postgres=# create table f(a integer defaul
Hello
2008/7/23 Maximilian Tyrtania <[EMAIL PROTECTED]>:
> Hi there, just a quickie: Is there a way to select all default values of a
> given table? Something like "Select Default values from sometable" ?
> Unfortunately this syntax doesn't seem to be supported. I know i can select
> the default v
am Wed, dem 23.07.2008, um 10:32:58 +0200 mailte Maximilian Tyrtania folgendes:
> Hi there, just a quickie: Is there a way to select all default values of a
> given table? Something like "Select Default values from sometable" ?
> Unfortunately this syntax doesn't seem to be supported. I know i can
Hi there, just a quickie: Is there a way to select all default values of a
given table? Something like "Select Default values from sometable" ?
Unfortunately this syntax doesn't seem to be supported. I know i can select
the default values for each column, but being able to select them in one go
wou
16 matches
Mail list logo
