Robert Fitzpatrick wrote:
I have a field with 'AA-BB-CC-DD' and I want to pull those four values
into an array and then loop through the array inserting records into a
table for each element. Can you someone point me to an example of this
in pl/pgsql?
Something like this?
create table
vishal saberwal wrote:
hi,
My server is Postgres 8.0.1 on fedora core2.
My clients are remote and interface with my server using .NET GUI.
We are trying to store many images/icons/audio/video clips in our system.
We expect many of these. The way we are doing it is using Hierarchical
File
Prepared statements are the way to go.
I developed my own prepared statements methodology (I called it SafeQuery)
some time back before discovering that others had done it. It's so nice,
since I've not worried about SQL injection for YEARS.
Sample of my API:
?
$sql=SELECT auth.login
FROM
Is there any way to covert an instance of a composite type to text,
to store it in a text column, and then to recreate the original object?
For example:
create type test as (a integer, b text);
create tble tstore (s text);
insert into tstore values((someproc((row(1, 'tst'))::test))::text);
I just installed postgresql 8.1-rc1 on a Windows 2003 machine. Since I
like psql a lot, and hate the cmd.exe terminal, I use puttycyg instead.
When I tried using psql.exe in a puttycyg terminal, after entering my
password for the database, the screen just hangs. When I do the same
from a cygwin
Bricklen Anderson [EMAIL PROTECTED] writes:
I couldn't find any useful references in the docs or archives for emitting the
line number of a plpgsql function (in a RAISE statement). I'd like to use it
for
debugging some complex functions.
Does anyone have any tips on where to look, or an
thanks for your response,
We are kind of jailing (may be hiding would be a better term) resources
behind the database/Stored procedures and GUI needs to have a feel as
if the data is comming from database.
Its a requirement for the project that any communication of resources and data be done
vishal saberwal [EMAIL PROTECTED] writes:
Did try finding something about HFS for ext3/xfs but in vain. The
information i found was the conversion between these file systems.
What exactly do you mean by HFS? All modern filesystems are
hierarchical.
-Doug
---(end of
HFS is the filesystem richard was tlking about. I am not familiar with
this file system but i guessed it was HFS+ that he was talking about.
yes, i understand all modern filesystems are Hirearchical file systems.
thanks,
vishOn 11/4/05, Douglas McNaught [EMAIL PROTECTED] wrote:
vishal saberwal
Jerry Sievers wrote:
Bricklen Anderson [EMAIL PROTECTED] writes:
I couldn't find any useful references in the docs or archives for emitting the
line number of a plpgsql function (in a RAISE statement). I'd like to use it
for
debugging some complex functions.
Does anyone have any tips on
vishal saberwal wrote:
HFS is the filesystem richard was tlking about. I am not familiar with
this file system but i guessed it was HFS+ that he was talking about.
yes, i understand all modern filesystems are Hirearchical file systems.
Ah, you said (H)ierarchical (F)ile (S)ystem in the
vishal saberwal [EMAIL PROTECTED] writes:
HFS is the filesystem richard was tlking about. I am not familiar with
this file system but i guessed it was HFS+ that he was talking about.
yes, i understand all modern filesystems are Hirearchical file systems.
Oh, OK--reading your original message,
Hello,
I know it is possible in other dbs like sqlite.
Let's say I have two tables which I want to join owners (name,age) and
dogs (name,owner,age).
select * from owners as a join dogs as b on a.name = b.owner
How could I convince postgres to prefix the returned columnnames with
the tablename
Hi,
OID being a 4 byte int seems limited to indexing for binary objects.
More precisely I use BLOB to store images in the database and link these
objects to another table using the OID as FK.
If I run out of OID there will be no way to index new images. Of course
when not automatically
On 11/1/05, Tom Lane [EMAIL PROTECTED] wrote:
Jan Wieck [EMAIL PROTECTED] writes:
On 10/31/2005 1:14 PM, Chris Browne wrote:
The fact that it appears a joke to people wanting to deploy big
databases doesn't prevent it from taking a painful bite out of, oh,
say, certain vendors that forgot
Hi
I wanted to try out the new role support in 8.1. My goal is to create
two roles, dev and admin, and make all other users member of those two
roles. The users shall then issue either set role dev (if the want
to to development work), or set role admin (in the rare case where
they need
Florian G. Pflug [EMAIL PROTECTED] writes:
grant admin to fgp ;
The last statement fails with role admin is a member of role fgp -
but I believe it is not.
Did I do something wrong, or is this really a bug?
Looks like a bug to me too. I think it's coming from the fact that
I think he meant
create sequence test_seq;
select setval('test_seq',(select max(primary_key_id) from my_table));
not max value of a serial type.
Alex
On 11/3/05, Marc Boucher [EMAIL PROTECTED] wrote:
On Wed, 02 Nov 2005 19:29:10 -0800, you wrote:
It's a migration thing - MySQL prevented
I am having a problem gettig a percent via division. Below is the first
part of my trigger function where pct returns 0.00, instead of the
expected 0.50. If I try without dimensions to the numeric variable, I
just get 0. What is the correct way to accomplish the percent?
CREATE OR REPLACE
Steven Brown [EMAIL PROTECTED] writes:
I'm granting access to insert/update/delete rows of a table to people,
but I don't want all future inserts to fail if they decided to change an
id (which they obviously shouldn't, but they /can/). It makes for a
fragile system.
create rule
Robert Fitzpatrick wrote:
I am having a problem gettig a percent via division. Below is the
first part of my trigger function where pct returns 0.00, instead of
the expected 0.50. If I try without dimensions to the numeric
variable, I just get 0. What is the correct way to accomplish the
See my comments below.
On Fri, 2005-11-04 at 15:24, vishal saberwal wrote:
thanks for your response,
We are kind of jailing (may be hiding would be a better term)
resources behind the database/Stored procedures and GUI needs to have
a feel as if the data is comming from database.
Its a
Hi,
I have a couple questions, I am tryingto write a function that
takes as input a list (size being dynamic) of primaryIDKeys, along with
a userdefined type and returns a set of rows containing those keys.
Furthermore the rows are exactly (columns) like the table that contains
the keys, but has
thanks for all your prompt reponses but i am still not clear with the way to solve the problem.I am sorry if i wasn't clear with my problem the first time.
My problem isn't file system and the way i lay it out.
What i need to know is a way to stream out external resource files via stored
On Fri, 2005-11-04 at 18:39 +0100, Tino Wildenhain wrote:
CREATE OR REPLACE FUNCTION public.issue (varchar) RETURNS numeric
AS'
DECLARE
repar text[];
pct numeric(3,2);
noreps integer;
BEGIN
repar := string_to_array($1,''-'');
noreps := array_upper(repar,1);
pct
yes, there is one, but i dont know how would you modify the PostgreSQL code.
You can implement a GUID datatype and can use it as indexing which guarantees uniqueness and can be stored in double format.
thanks,
vishOn 11/4/05, Lolke B. Dijkstra [EMAIL PROTECTED] wrote:
Hi,OID being a 4 byte int
Hello everyone:
I'm working to upgrade a database from PostgreSQL
7.3 to 8.0 version.The database serves a complex J2EE application, running
Jboss in multiple servers. All servers run Linux RedHat.I found a problem
yesterday.Whenever the application inserts a date prior to 1914-01-01, the
Am Freitag, den 04.11.2005, 12:13 -0500 schrieb Robert Fitzpatrick:
I am having a problem gettig a percent via division. Below is the first
part of my trigger function where pct returns 0.00, instead of the
expected 0.50. If I try without dimensions to the numeric variable, I
just get 0. What
This is what i can't get right:
CREATE type tst_tst as (a integer, b text);
CREATE OR REPLACE FUNCTION tst_store(a anyelement) RETURNS text AS $$
BEGIN
RETURN textin(record_out(a));
END
$$ LANGUAGE PLPGSQL;
create or replace function tst_load1(a text) returns tst_tst as $$
declare
We have a similar functional requirement to Vishal's, but with an
added twist. Currently, we are utilizing the pg_largeobject table to
store context data delivered through our java application. We are
finding, however, that very large pg_largeobject tables degrade our
performance in other areas
On Thu, Nov 03, 2005 at 10:29:56PM -0500, Christopher Browne wrote:
On Wed, Nov 02, 2005 at 03:44:26PM -0800, Marc Munro wrote:
experts there may suggest a better solution. I have seen talk of
disabling the standard slony triggers to allow this sort of thing but
whether that is more or
On Thu, Nov 03, 2005 at 03:22:34PM -0600, Cristian Prieto wrote:
Save globally for all session or between sessions.
Well, I have a set of queries which runs several times. My clients connect
and execute it. But each time the client connects and disconnects, that
means that I loose the
Assad Jarrahian [EMAIL PROTECTED] writes:
How do you take in a list of int?
Use an array.
regards, tom lane
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
Hi,
Here is an example
Regards
/David
CREATE OR REPLACE FUNCTION
usp_Inventaire_Transaction_Statut_Changer(int[], varchar, int, date)
RETURNS INTEGER AS '
DECLARE
requestIds ALIAS FOR $1;
companyId ALIAS FOR $2;
targetStatus ALIAS FOR $3;
transactionDate ALIAS FOR $4;
transactionDate_
But if someone decided to fork their own *new* project, perhaps
starting based on one of the releases, that would an entirely
interesting idea.
Wouldn't async multimaster make use of most all of what slony-I
currently has? ISTM that it would make life a lot easier to use one
combined
At 11:49 04/11/2005 -0500, Alex Turner wrote:
I think he meant
create sequence test_seq;
select setval('test_seq',(select max(primary_key_id) from my_table));
not max value of a serial type.
What I understand, and from what I know by using mysql, is that mysql
auto-adjust the max value of a
All,
I have a duplicate row problem and to make matters worse some tables
don't have a PK or any unique identifier. See below:
uid | cleanval | timestamp | received
-+---++--
38 | 5 | 1125081799 |1
38 |14 | 1122683252 |0
38 | 5 |
Peter Atkins [EMAIL PROTECTED] writes:
I was hoping to have a system oid for each row but it looks like that's
not the case. Anyone have any thoughts on how to remove dups?
ctid always works ...
regards, tom lane
---(end of
CREATE TABLE new_name AS SELECT DISTINCT * FROM old_name;
DROP TABLE old_name;
ALTER TABLE new_name RENAME TO old_name;
On 2005-11-04 17:15, Peter Atkins wrote:
All,
I have a duplicate row problem and to make matters worse some tables don't have a PK or any unique identifier.
Anyone have
39 matches
Mail list logo
