[SQL] hi

I want to fix the pay based on joining date and antedate...antedate is the last date... Joining date is 01-07-2007 Antedate is 04-07-2005.. On joining date I will fix the pay but before fixing the pay I will check whether antedate is there or not, if its there then I will see difference be

Re: [SQL] hi

John Summerfield wrote: Penchalaiah P. wrote: Information transmitted by this e-mail is proprietary to Infinite Computer Solutions It may be proprietary, but it shore ain't confidential! Placing "confidential" on every document without regard for its content, especially when some of it's

Re: [SQL] hi

Penchalaiah P. wrote: Information transmitted by this e-mail is proprietary to Infinite Computer Solutions It may be proprietary, but it shore ain't confidential! ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore y

Re: [SQL] hi

Try pgAdmin - Google will find it for you. ~p On Wed, 2007-04-25 at 10:10 +0530, saji varghese wrote: > > Hi, > Can i get GUI tool for PostgreSQLin LINUX.Pls let me know from wher i > candownload the same. > ***Confidentiality and Privilege Notice*** The ma

Re: [SQL] hi

ent: Tuesday, 24 April, 2007 6:15:13 PM Subject: Re: [SQL] hi Select sno AS “SNO”, SELECT value AS “VALUE”, get_sum(value) as SUM from temp; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P. Sent: April 24, 2007 8:09 AM To: pgsql-sql@postgresql.org Subject:

Re: [SQL] hi

On Tue, 24 Apr 2007, Penchalaiah P. wrote: > Hi > > I have the data like this in temp table > > SQL> Select sno, value from temp; > > SNO Value > > 1 650.00 > > 2 850.00 > > 3 640.00 > > 3 985

Re: [SQL] hi

On þri, 2007-04-24 at 17:39 +0530, Penchalaiah P. wrote: > Hi > > I have the data like this in temp table > > SQL> Select sno, value from temp; you seem to be assuming a specific order for this. gnari ---(end of broadcast)--- TIP 9: In versio

Re: [SQL] hi

Hi, try this. It's working... SELECT t1.sno, sum(t2.value) FROM temp as t1, temp as t2 WHERE t1.sno >= t2.sno GROUP BY t1.sno; but not completely. The problem is the this suppose your sno is uniqu. But as I see 3 is not. Anyway it may help you. >I have the data like this in temp table > >SQL>

Re: [SQL] hi

Select sno AS "SNO", SELECT value AS "VALUE", get_sum(value) as SUM from temp; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P. Sent: April 24, 2007 8:09 AM To: pgsql-sql@postgresql.org Subject:

[SQL] hi

Hi I have the data like this in temp table SQL> Select sno, value from temp; SNO Value 1 650.00 2 850.00 3 640.00 3 985.00 5 987.00 9 9864.00

Re: [SQL] hi any one can help me

On 12/3/06, Penchalaiah P. <[EMAIL PROTECTED]> wrote: Hi … I installed postgresql 8.1 .. then I uninstalled postgresql.. Now again I am re installing the same postgresql 8.1 .. but its not installing .its giving error like *already user exists* its showing… I removed those files

Re: [SQL] hi any one can help me

You will need to manually remove the postgresql folder under Program files because uninstalling does not remove that folder for you. - Original Message From: Penchalaiah P. <[EMAIL PROTECTED]> To: pgsql-sql@postgresql.org Sent: Sunday, December 3, 2006 5:33:41 AM Subject: [SQL]

[SQL] hi any one can help me

Hi ... I installed postgresql 8.1 .. then I uninstalled postgresql.. Now again I am re installing the same postgresql 8.1 .. but its not installing .its giving error like already user exists its showing... I removed those files from registry also.. but I am getting same error...

Re: [SQL] hi may i know y am i getting this error

am Fri, dem 17.11.2006, um 15:15:25 +0530 mailte Penchalaiah P. folgendes: > Hi > > When I am executing my function its giving error.. first time its running > properly.. but when I am executing second time I am getting error > > create or replace function irla_punching_medium_insert1(in_proj_co

Re: [SQL] hi may i know y am i getting this error

Penchalaiah P. wrote: Hi When I am executing my function its giving error.. first time its running properly.. but when I am executing second time I am getting error create table dummy_table without oids as ... update dummy_table set irla_code=l_p where irla_code=''P''; ... ERR

[SQL] hi may i know y am i getting this error

Hi When I am executing my function its giving error.. first time its running properly.. but when I am executing second time I am getting error create or replace function irla_punching_medium_insert1(in_proj_code numeric,in_pt_code varchar,in_mon_abs date) returns varchar as' declare l_p va

Re: [SQL] hi i am getting error...can u solve this

: pgsql-sql@postgresql.org Subject: [SQL] hi i am getting error...can u solve this   Hi can u tell me about this problem..   cda_no  bp npa   rp dp pay_change_date   234597D   7900 400   1000 1000 2006-09-05 234597D   8250 400

Re: [SQL] hi i am getting error...can u solve this

On Thu, Nov 02, 2006 at 06:19:45PM +0530, Penchalaiah P. wrote: > > This is the table it contains some sample data.. but I want to see > difference between Between what? A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a good way of saying November.

[SQL] hi i am getting error...can u solve this

Hi can u tell me about this problem..   cda_no  bp npa   rp dp pay_change_date   234597D   7900 400   1000 1000 2006-09-05 234597D   8250 400   1000 1000 2005-09-05 234575E   4000 200   333

Re: [SQL] hi i want help on levels

Search the archives for hierarchical query. -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] hi i want help on levels

CREATE TABLE admin_activity (   activity_id int4 NOT NULL,   Activity_name varchar NOT NULL,   URL varchar,   parent_activity_id int4);   1  Administration   0 2  Activities   1 3  Manage Activity 2 4  Map

Re: [SQL] hi i am gettin error when i am deleting a function from my pgadmin

On 9/11/06, Penchalaiah P. <[EMAIL PROTECTED]> wrote: Hi good morning to all…. I created some functions in my pgadmin… when I am deleting those functions from that pgadmin its giving error…i.e   An ERROR  has occurred   ERROR:function function_name1(character varying, characte

Re: [SQL] hi i am gettin error when i am deleting a function from

Can you give us the actual delete command you are issuing? You need to specify the types of the function arguments when deleting functions, for example: DELETE FUNCTION my_sum (int, int); etc. Cheers, Bob Edwards. Penchalaiah P. wrote: Hi good morning to all…. I created some functions in

Fwd: [SQL] hi i am gettin error when i am deleting a function from my pgadmin

On 9/11/06, Penchalaiah P. < [EMAIL PROTECTED]> wrote: Hi good morning to all…. I created some functions in my pgadmin… when I am deleting those functions from that pgadmin its giving error…i.e   An ERROR  has occurred   ERROR:function function_name1(character varying, charact

[SQL] hi i am gettin error when i am deleting a function from my pgadmin

Hi good morning to all…. I created some functions in my pgadmin… when I am deleting those functions from that pgadmin its giving error…i.e   An ERROR  has occurred   ERROR:function function_name1(character varying, character varying, character varying, date, character varying) does

Re: [SQL] hi ........i have a query related to MS reporting services

> HI to all of you. I am a new member of this group and this is my > first mail in this group.I am working in MS Reporting services.And > i am new in this job. > > I have a problem. > There is a table which has many columns. > and i have to give selection to client that he can select any top > 10,

[SQL] hi ........i have a query related to MS reporting services

HI to all of you. I am a new member of this group and this is my first mail in this group.I am working in MS Reporting services.And i am new in this job.   I have a problem. There is a table which has many columns. and i have to give selection to client that he can select any top 10,25,500,1000

Re: [SQL] hi let me know the solution to this question

On 7/18/06, Bricklen Anderson <[EMAIL PROTECTED]> wrote: Aaron Bono wrote:> On 7/18/06, *Michael Fuhr* <[EMAIL PROTECTED] [EMAIL PROTECTED]>> wrote:> http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS>> OK, this question got me wondering: is t

Re: [SQL] hi let me know the solution to this question

Aaron Bono wrote: On 7/18/06, *Michael Fuhr* <[EMAIL PROTECTED] > wrote: http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS OK, this question got me wondering: is there a way to determine, in a function/stor

Re: [SQL] hi let me know the solution to this question

On 7/18/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Tue, Jul 18, 2006 at 10:46:29AM +0530, Penchalaiah P. wrote:> Can u let me know if at all any system defined variable exists to check> whether insert , update , and delete is successfully executed in a > stored procedure>> So that I can

Re: [SQL] hi let me know the solution to this question

On Tue, Jul 18, 2006 at 10:46:29AM +0530, Penchalaiah P. wrote: > Can u let me know if at all any system defined variable exists to check > whether insert , update , and delete is successfully executed in a > stored procedure > > So that I can perform some steps based on the result of exe

[SQL] hi let me know the solution to this question

Hi good morning all……..   Can u let me know if at all any system defined variable exists to check whether insert , update , and delete is successfully executed in a stored procedure……..   So that I can perform some steps based on the  result of execution if possible please send me the s

Re: [SQL] hi i need to connect database from my system to another

> I am using windows xp operating system... > I want to know how to connect remote postgresql from my system.. I need > brief description from beginning.. > Now I am using pg_HBF conf file to connect remote postgresql in that I > am giving host name , ip-address,mask and trust... but it is showing

Re: [SQL] hi i need to connect database from my system to another

: Penchalaiah P. Cc: General Postgresql List Subject: RE: [SQL] hi i need to connect database from my system to another system > If u don't mind can u please tell me clearly.. where I have start -I or > how to start postgresql with -I > > I am using postgresql database server... in

Re: [SQL] hi i need to connect database from my system to another system

> If u don't mind can u please tell me clearly.. where I have start -I or > how to start postgresql with -I > > I am using postgresql database server... in my system.. if I want to > > connect to this database server from other system..Or how can I use > this > > database server in other machine

Re: [SQL] hi i need to connect database from my system to another system

> I am using postgresql database server... in my system.. if I want to > connect to this database server from other system..Or how can I use this > database server in other machine .. > > How can I do this..if any one have idea about this please give me brief > description You need to start the

[SQL] hi i need to connect database from my system to another system

Hi good afternoon to every one..   I am using postgresql database server… in my system.. if I want to connect to this database server from other system..Or how can I use this database server  in other machine .. How can I do this..if any one have idea about this please give me brief desc

Re: [SQL] hi i need to encrypt one field in a table

On Tue, 2006-05-30 at 15:42 +0530, Penchalaiah P. wrote: > Hello, > I want to create a table with an encrypted field for a password entry, so > that you can see only . > And can I encrypt fields which datatype is an integer or a timestamp? No can do. I mean, you can't do something like tha

Re: [SQL] hi i need to encrypt one field in a table

For SQL-passwords usually use hashes... 2006/5/30, Penchalaiah P. <[EMAIL PROTECTED]>: Hello, I want to create a table with an encrypted field for a password entry, so that you can see only . And can I encrypt fields which datatype is an integer or a timestamp? Hi pls let me know th

[SQL] hi i need to encrypt one field in a table

Hello,I want to create a table with an encrypted field for a password entry, sothat you can see only .And can I encrypt fields which datatype is an integer or a timestamp?  Hi pls let me know this………..   Thanks  &  Regards Penchal reddy | Software Engineer    Infinite Com

Re: [SQL] hi still i am unable to provide encryption to a particular table....

On Mon, May 29, 2006 at 03:13:59PM +0530, Penchalaiah P. wrote: > and port number here wt I will get... my requirement is to do encryption > to one of my table.. if any body knows about this please help me Is this one-way encryption (i.e. you want a hash?) You can use built-in md5 for tha

[SQL] hi still i am unable to provide encryption to a particular table....

Hi   I have gone thru encryption in postgresql help… but there I got some message like set some comments in pg_hba.conf file.. if I set host name and port number here wt I will get… my requirement is to do encryption to one of my table.. if any body knows about this please help me……..  

Re: [SQL] hi how to use encryption for incomtax in postgresql

Penchalaiah P. wrote: hi sir how to use encryption to password in postgresql with examples It depends on what you're trying to achieve - password protection, concealing data, encrypting a connection. The md5() function is built-in, and may be suitable for password protection on a simple we

Re: [SQL] hi how to use encryption for incomtax in postgresql

On Fri, May 26, 2006 at 04:01:47PM +0530, Penchalaiah P. wrote: > hi sir > > > > how to use encryption to password in postgresql with examples I guess you want to read this: http://www.postgresql.org/docs/8.1/interactive/client-authentication.html ? A -- Andrew Sullivan | [EMAIL PROTECTE

[SQL] hi how to use encryption for incomtax in postgresql

hi sir   how to use encryption to password in postgresql with examples   Thanks  &  Regards Penchal reddy | Software Engineer    Infinite Computer Solutions | Exciting Times…Infinite Possibilities... SEI-CMMI level 5 | ISO 9001:2000 IT SERVICES | BPO

Re: [SQL] hi can u give solution to this query

  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P.Sent: 23 May 2006 13:41To: pgsql-sql@postgresql.orgSubject: [SQL] hi can u give solution to this query Hi sir…    If u don’t mind can u reply for this  question   This is

[SQL] hi can u give solution to this query

Hi sir…    If u don’t mind can u reply for this  question   This is one table… it has one primary key…….so I can insert the values from  data edit…   1)…CREATE TABLE "ADV" (   "T-Section_Id" varchar(10) NOT NULL,   "CDA_No" varchar(7) NOT NULL,   "Imp_Schedule_Id" int4 NOT NULL,

Re: [SQL] hi all......................!!

Hi, Akilesh, AKHILESH GUPTA wrote: > i am new to this mailing list. this is my first mail to this group. > i jussst want to confirm that whether is it possible to update a view or > not?? > i think you all help me in solving my queries in future...!! Do you think about issuing UP

Re: [SQL] hi all......................!!

AKHILESH GUPTA wrote: hello everybody i am new to this mailing list. this is my first mail to this group. i jussst want to confirm that whether is it possible to update a view or not?? There is no automatic updating of views at present. You can write your own RULES though to do updates - see t

[SQL] hi all......................!!

hello everybody i am new to this mailing list. this is my first mail to this group. i jussst want to confirm that whether is it possible to update a view or not?? i think you all help me in solving my queries in future...!! -- Thanks & Regards, Akhilesh DAV Institute of Managem

Re: [SQL] Hi

* vasundhar <[EMAIL PROTECTED]> [2004-11-06 22:45:36 -0800]: > Hi I am using REL on which only 7.3.2 PG only available and I want > to upgrade it to the latest and also integrate it with Perl but my > system is also not supporting the DBI any suggestions please My suggestion would be to determine

[SQL] Hi

Hi I am using REL on which only 7.3.2 PG only available and I want to upgrade it to the latest and also integrate it with Perl but my system is also not supporting the DBI any suggestions please ---(end of broadcast)--- TIP 8: explain analyze is you

Re: [SQL] hi sir urgent..required a Query

Rajeev, > I am attaching a document with this file showing two table.. < you.doc>> > > It consist of two table VALUE AND VALUE_TYPE.. > > when i have value_type_id=1 i must get Value_varchar column value > > when i have value_type_id=2 i must get Value_int column value > Please send a SQL query fo

[SQL] hi sir urgent..required a Query

Hi Sir, I am attaching a document with this file showing two table.. <> It consist of two table VALUE AND VALUE_TYPE.. when i have value_type_id=1 i must get Value_varchar column value when i have value_type_id=2 i must get Value_int column value Please send a SQL query for this... I want to

[SQL] hi

i'd like to tranfer sql schema from MS serverExample:***1*if exists (select * from sysobjects where id = object_id(N'[admin].[test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [admin].[test] go***2**

Re: [SQL] Hi there, having problems with the following:

You'll probably want something like null::varchar (or other appropriate type) for the nulls. It's trying to grab the type from the first select and can't figure the type out for the null. (Technically speaking, it's probably supposed to be CAST(NULL AS VARCHAR) to be technically sql complient,

[SQL] Hi there, having problems with the following:

Hi there, having problems with the following: On Postgresql (on Linux) I have 3 tables: 1)employee firstname lastname initials 2)has_title initials title 3)has_trade initials trade Now, what I would like is to get a list of all employees with all their titles and trades - employees can have

Re: [SQL] HI! Problems with cursors into triggers

On Wed, 28 Jun 2000, Andrés Mauricio Marín Restrepo wrote: > > HELLO! > > I'm making one trigger (plpgsql) and in the function i use CURSOR for to > > bring an elements and to take them to a variable but no me it does not > work, WHY? > > The script is: > > DROP TRIGGER miTrig on

[SQL] HI! Problems with cursors into triggers

HELLO! I'm making one trigger (plpgsql) and in the function i use CURSOR for to bring an elements and to take them to a variable but no me it does not work, WHY? The script is: DROP TRIGGER miTrig on otro; DROP FUNCTION miFunc(); DROP TABLE otro; DROP TABLE cual; CREATE TABLE otro

[SQL] HI! Problems with cursors into triggers

HELLO! I'm making one trigger (plpgsql) and in the function i use CURSOR for to bring an elements and to take them to a variable but no me it does not work, WHY? The script is: DROP TRIGGER miTrig on otro; DROP FUNCTION miFunc(); DROP TABLE otro; DROP TABLE cual; CREATE TABLE otro