2008/7/11 daniel blanco <[EMAIL PROTECTED]>:
> Hi Everyone
>
> I would like to know if i can create a function that returns a set of record
> with the sql statement: select and a integer, i mean both of them, because i
> remenber that in sql server (transact sql) i can do that in a stored
> procedu
On Fri, 2008-07-11 at 18:56 -0700, Lewis Cunningham wrote:
> In addition to allowing you to read old data, Flashback will allow you
> to rollback to a point in time, including returning a single table to
> a specific state. Flashback database is like PITR without the log
> files.
Like I said: y
> While the optimizer theoretically could deduce the extra restriction
> condition, it doesn't attempt to. It's extremely unclear that the extra
> cycles to look for such cases would be repaid on average, because cases
> like this aren't that common. The current state of affairs is that
> the sys
On Sat, Jul 12, 2008 at 8:56 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> Please don't put links to copyrighted material on our lists.
That's an odd thing to say, given that virtually every link on our
lists probably points to material copyrighted in some way.
--
Dave Page
EnterpriseDB UK: htt
Hai Kretschmer ,
Thanks for your reply, it help to solve my problem. I have few for doubts
regarding dynamic query
I have a table structure:
Column | Type | Modifiers
+--+---
mf | double precision |
sf | double precision |
comm | inte
On Sat, 2008-07-12 at 09:40 +0100, Dave Page wrote:
> On Sat, Jul 12, 2008 at 8:56 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
> >
> > Please don't put links to copyrighted material on our lists.
>
> That's an odd thing to say, given that virtually every link on our
> lists probably points to mate
On lau, 2008-07-12 at 14:45 +0530, Anoop G wrote:
> Hai Kretschmer ,
>Thanks for your reply, it help to solve my problem. I have few for
> doubts regarding dynamic query
...
> vchr_query:= 'SELECT mf,sf,(mf – mf * comm /100) – (sf – sf *
> comm/100) as flt_claim';
the '–' characters here proba
I'm trying to make a PL function to pass from an alphanumeric string
to a numeric one changing the chars in the string to it's ORD (the
inverse of the chr function) and I'm stumbling with two problems:
1) How to know if the CHAR is numeric or not.
2) If it's not numeric I want to get it's ord, but
On Sat, Jul 12, 2008 at 3:20 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> On Sat, 2008-07-12 at 09:40 +0100, Dave Page wrote:
>> On Sat, Jul 12, 2008 at 8:56 AM, Simon Riggs <[EMAIL PROTECTED]> wrote:
>> >
>> > Please don't put links to copyrighted material on our lists.
>>
>> That's an odd thing
Hello
2008/7/12 Martín Marqués <[EMAIL PROTECTED]>:
> I'm trying to make a PL function to pass from an alphanumeric string
> to a numeric one changing the chars in the string to it's ORD (the
> inverse of the chr function) and I'm stumbling with two problems:
>
> 1) How to know if the CHAR is nume
2008/7/12 Pavel Stehule <[EMAIL PROTECTED]>:
> Hello
>
> 2008/7/12 Martín Marqués <[EMAIL PROTECTED]>:
>> I'm trying to make a PL function to pass from an alphanumeric string
>> to a numeric one changing the chars in the string to it's ORD (the
>> inverse of the chr function) and I'm stumbling with
"Robins Tharakan" <[EMAIL PROTECTED]> writes:
> Besides, I did a simple test and although you are right about the optimizer
> deducing implied equality conditions, this holds true only for a direct
> join. In the second query, the optimizer recommends a table scan even for a
> simple IN() condition
>
> Please don't put links to copyrighted material on our
> lists.
>
Postgres docs are copyrighted. The oracle docs are free to access just like
the postgres docs. What is the issue?
LewisC
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription
--- On Sat, 7/12/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> What I would appreciate as regards Oracle's flashback
> technology would
> have been a link to a well written review showing the warts
> as well as
> the beauty. I've found that Oracle stuff sounds good
> on paper, and
> turns into a
At 11:59 AM 7/12/2008, [EMAIL PROTECTED] wrote:
Date: Sat, 12 Jul 2008 10:20:37 +0100
From: Simon Riggs <[EMAIL PROTECTED]>
To: Dave Page <[EMAIL PROTECTED]>
Cc: Lewis Cunningham <[EMAIL PROTECTED]>, Scott Marlowe
<[EMAIL PROTECTED]>, samantha mahindrakar
<[EMAIL PROTECTED]>, pgsql-sql@postgre
Steve writes:
> I don't want to pile more wood on the fire, but I think I can see both
> sides to this. I believe this is not so much copyright violation concern,
> but if the Pg team releases some cool feature relating to rollbacks
> down-the-road that is vaguely similar to Oracle's system, reduci
Ok, thanks pavel. i think i'll try set of cursors. by the way
in t-sql i did it as follows:
table users with a field called name
create procedure list_user_by_name
@info_name varchar
as
declare @sw
begin
select @n=(select count(*) from users where name like (@info_name+
Hello
2008/7/13 daniel blanco <[EMAIL PROTECTED]>:
> Ok, thanks pavel. i think i'll try set of cursors. by the
> way in t-sql i did it as follows:
> table users with a field called name
>
> create procedure list_user_by_name
> @info_name varchar
> as
> declare @sw
> begin
>
Ok, i see... well. when i have to return a set of records i'll use
sql and when i have to do stored procedure of functions i'll use plpsql in this
case but you're telling me that it will change in the 8.4 version. won't it?
> Date: Sun, 13 Jul 2008 07:06:07 +0200> From: [EMAIL PR
19 matches
Mail list logo
