Hello,
I have a table called X
it contains 3 fields of importance(amongst others).
time (timestamp), snooze (int) , inbox (int)
The time column sometimes has null values.
What I want is that every time a row is selected, if the time is a
null value, it is set to now() and snooze is set to 0 and
I have a query that takes two tables (join) and does something on it.
Lets say these tables are A and B.
What I need is that everytime one of the tables (A) has its rows
selected, I want to update the count (which is a column in A) for that
row.
I am not sure what is the best way to do this.
1)I c
So is it still advisable not to store it in a string format like
'jarraa, mooreg3, flowerpower' [read my comments below please]
awaiting some feedback.
-assad
On 1/12/06, Assad Jarrahian <[EMAIL PROTECTED]> wrote:
> Alban and Tino,
> More explanations lie below.
> A d
t;document" To
users, and To groups. The constrainfo user being the user is in the db
and for groups, he/she has to be a member of it.
Users Schema
(username, userInfo)
Group Schema (2 tables)
(groupID, groupname, groupInfo)
(groupID, oneOfTheManyGroupMembers)
Hope this helps and that I
>
> There is ;) But I doubt Tom likes to show you the dark side [tm] ;)
hehe
maybe I can do a hybrid, storing the string completely in the doc
table and storing all the to fields as a document_to table.
Awaiting your thoughts.
thanks!
-Assad
>
>
> ...
> >
> >
&
document to a stored procedure and then the stored
procedure takes the text component of it and tokenizes it and then I
do constraint checks on it?
thanks.
-assad
On 1/11/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Assad Jarrahian <[EMAIL PROTECTED]> writes:
> > A column
Problem:
A column of type text contains username's and groupname's followed
by comma (eg. 'jarraa, mooreg3, keith') [it is stored this way
because it will be displayed in this format].
What is needed is a constrain check. To make sure that every time a
row is inserted into the table, this colum
ng to install postgis on the debian box and
cannot find the contrib directory.
thanks for your help
-assad
On 1/11/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> [Please copy the mailing list on replies.]
>
> On Wed, Jan 11, 2006 at 08:02:56PM -0700, Assad Jarrahian wrote:
> &g
find
any in my db (I presume I do not have postgis installed). How would I
go about installing (debian apt) and adding it to my current db.
Much thanks in advance.
-assad
On 1/11/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, Jan 11, 2006 at 02:40:04PM -0700, Assad Jarrahian wro
Hi,
I was running postgres 8.1 on a windows xp box and I recall
installing it with postgis option.
I had a method in a db there that called geodistance. Everything worked fine.
Now I tried to restore the db on the debian server thats running 8.1
as well. The geodistance function (or any other ge
t; On Mon, Jan 09, 2006 at 05:33:53PM -0700, Assad Jarrahian wrote:
> > I have a pg_psql stored procedure
> >
> > getlms(_int4)
> >
> > from psql
> >
> > SELECT * fROM get_lms(ARRAY[12,23,34]);
> >
> > that does not work. How do I pass an array t
I have a pg_psql stored procedure
getlms(_int4)
from psql
SELECT * fROM get_lms(ARRAY[12,23,34]);
that does not work. How do I pass an array to a function in psql?
Please help. Thanks.
-assad
---(end of broadcast)---
TIP 1: if posting/reading thr
much appreciated.
-assad
On 1/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Assad Jarrahian <[EMAIL PROTECTED]> writes:
> > UPDATE userprofiles SET address = ROW(
> > ,'','','',,'',,'','','',''
.
UPDATE userprofiles SET address = ROW(
,'','','',,'',,'','','','','','','','','','') where
username='mooreg3';
ERROR: syntax error at or near &quo
Hello,
So I have been reading over the web and it seems that one must
define two methods before declaring a type. But I seem to have done it
(CREATE TYPE) without creating any functions and it did not give me
an error. I tried to use
INSERT TABLENAME SET user-defined-column = ROW('val1' ,'va2'
Hi All,
I am quite confused (PLEASE PLEASE Help), I cannot find anything on
the web). I read that you can declare a class that implements SQLData
(in this case I set up a class called Complex from the /src/tutorial
datatype that mimics the user-defined datatype in the db) and then set
the mapping
Environment: Deployed on Debian. Test and Development on Windows.
Using pg_admin III and Postgresql 8.1 (both test and development).
I want to backup Development and restore it in test and vice-versa.
So when I do a backup of the db (in PGAdmin III), it backs it up. But
when I restore it, all pri
Hi All,
So I am trying to store images in the db which will be accessed from
a midlet and website.
So I looked into generating temp files, such as the one done here
using servlets (http://fdegrelle.over-blog.com/categorie-275139.html).
What I am confused about is that this may not be very effic
x27;t give us enough information to diagnose this. I
> recommend you find the queries that are being run by Java and type them
> into psql to see if they work there. If not, please show them to us.
>
> ---
>
>
Hi all,
So I started to make some changes with my code here and there
(nothing to do with the relevant lines) and suddenly currval and
rollback don't work.
try{
db.setAutoCommit(false);
addLM.setInt(1, lm.getOrigin());
Hi all,
I have a design decission to make. I am using Lucene (Java Search
API) and I need to update lucenes index from time to time.
Is there a way one can keep track of all the inserts coming
into a table (holding onto their Primary key's are sufficient) and
then reseting that after a c
Hi All,
I have a quick question. So I pass an array (int containing primary
keys) to a pgSQL function and I want the results to be in the exact
same order as the ints in the array. Is there a way to do this ?
currently my code looks like this
CREATE OR REPLACE FUNCTION getlms(_int4)
RETURNS S
Hi All,
I am a bit stumped. So I have a couple of Postgresql versions on my
server, namely 8.0 and 8.1 (using Debian package manager). I am trying
to get 8.1 to be the default database and delete 8.0
I used pg_dump to dump my db's into a file (Question: Where do I dump
the data of the tables in
Hi,
I am trying to write a stored procedure that takes as input an array
(one or more integers) and returns all rows matching that ID (primary
key of the table):
I have this so far:
CREATE OR REPLACE FUNCTION
getLMs(int[],float(8), float(8)) RETURNS SETOF tp_lm_object AS $$
DECLARE
myrec r
Got it. I will be more careful with words.
Thanks tom for getting 8.1!
one more question.
Where does the directory lie for psql (so I can put a .sql file in there and run it) for windows?
thanks.
-assad
On 11/8/05, Richard Huxton <dev@archonet.com> wrote:
Assad Jarrahian wrote:> Sorr
with knowledge. Be
curtious.
Thanks.
-assad
On 11/8/05, Richard Huxton <dev@archonet.com> wrote:
Assad Jarrahian wrote:>> \c does not work in .sql script run in psql.That sounds unlikely. What sort of error message are you getting?-- Richard Huxton Archonet Ltd
, Klint Gore <[EMAIL PROTECTED]
> wrote:
On Sun, 6 Nov 2005 18:06:11 -0700, Assad Jarrahian <[EMAIL PROTECTED]> wrote:> Hi,> I am writing a .sql file to create a database, connect to it and create
> tables etc. (basic db setup).
> But I cannot figure out how to connect to the serv
Hi,
I am writing a .sql file to create a database, connect to it and create tables etc. (basic db setup).
But I cannot figure out how to connect to the server (what statement) in a .sql file.
any help would be appreciated.
-assad
using the CallableStatement in
JDBC. I cannot seem to understand how to use setArray() succesfully?
Any help would be appreciated. Much thanks.
-assad
On 11/4/05, Tom Lane <[EMAIL PROTECTED]> wrote:
Assad Jarrahian <[EMAIL PROTECTED]> writes:> How do you take in 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
30 matches
Mail list logo