your attention to this matter.
Kevin Duffy
ld it be called?
If I put it in parentheses, how many times would it be called?
Any comments from the PostgresSQL gurus out there?
Happy Friday.
KD
From: Dan McFadyen [mailto:d...@cryptocard.com]
Sent: Friday, March 20, 2009 3:51 PM
To: Kevin
would be calc'ed by
using a cursor to step through
CAPITALIZATIONLEVEL from lowest to highest. This function would be
declared STABLE.
Which method would execute more efficiently?
Thanks for considering my issue.
Kevin Duffy
CREATE TABLE capitalization
.
Does anybody know if a where-used function exists for the wonderful
database known as Postgres?
Many Thanks
Kevin Duffy
n_bbcode := replace(abbcode[1], '/', '') ||' '|| abbcode[3];
else
rtn_bbcode := tmp_bbcode; -- simple pass though case does
not work?!?!
end if;
end if;
return rtn_bbcode ;
END
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Kevin Duffy
Take a look at LIKE or ILIKE
kd
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Duffy
Sent: Friday, November 21, 2008 11:31 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] function - string ends with
Hello All:
Is anyone aware
Hello All:
Is anyone aware of a function in PgSQL that will check if a string ends
with a specific string?
I.e. rposition(substring in string ) returns int
Starts searching right to left within string
Thanks for your attention to this matter.
Kevin Duffy
f record 2 in IMPORT_INV is for the same clothing item as
record 27, and this a new inventory item,
but for different locations. Will this new inventory item get
added twice to my ITEM table.
Many thanks for considering this issue.
Kevin Duffy
On Wednesday 29 October 2008 18:39:42 Kevin Duffy wrote:
> Hello:
>
>
>
> I have a couple of queries that are giving me headaches.
>
> They are actually very simple, but I do not understand why
>
> I am not getting the expected results. Maybe I need new g
x_ (index_key) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_tmpindexmember_taskrun FOREIGN KEY (taskrunkey)
REFERENCES taskrun (taskrunkey) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITHOUT OIDS;
ALTER TABLE tmp_index_member OWNER TO postgres;
Kevin Duffy
WR Capital Management
--
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2008 5:35 PM
To: Kevin Duffy
Cc: pgsql-sql@postgresql.org; Frank Bax
Subject: Re: [SQL] variables with SELECT statement
On Fri, Sep 5, 2008 at 3:28 PM, Kevin Duffy <[EMAIL PROTECTED]>
wrote:
> No looks like I h
et me guess I have to upgrade.
kd
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Friday, September 05, 2008 5:27 PM
To: Frank Bax
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] variables with SELECT statement
Frank Bax <[EMAIL PROTECTED]&
No looks like I have 8.2
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Bax
Sent: Friday, September 05, 2008 5:13 PM
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] variables with SELECT statement
Kevin Duffy wrote:
> Just testing
EMAIL PROTECTED]
Sent: Friday, September 05, 2008 4:47 PM
To: Kevin Duffy
Subject: Re: [SQL] variables with SELECT statement
2008/9/5, Kevin Duffy <[EMAIL PROTECTED]>:
> OK that is a syntax I have never seen. But correct we are getting
> close.
>
> Noticed that string_to_array does no
al Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Bax
Sent: Friday, September 05, 2008 4:07 PM
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] variables with SELECT statement
Kevin Duffy wrote:
> Within my table there is a field DESCRIPTION that I would like to
tance is requested.
Thanks
Kevin Duffy
WR Capital Management
40 Signal Rd
Stamford, CT
203-504-6221
close to Oracle
PL-SQL is Postgres? Would a Oracle PL-SQL book cover the
basics?
Remember be kind to
the newbee.
Kevin Duffy
17 matches
Mail list logo