Search results for query: *

I have not been able to figure out howto return a string of spaces from a postgres PLpgSQL function. For example I have a finalresult field defined as varchar. As I LOOP thru a section of code I set finalresult := finalresult || '' '' || field1 || '',''|| field2; and then I issue...

I am trying to write a select statement using Postgres to get the top 3 users in each problem category with the most problem incidents. For example: email problems: mary 5 jason 3 amy 2 beth 1 riley 1 network problems: bob 7 john 6 fred 4 howard 2 amy 1 sue 1 The results would produce: email...

1) I am testing out phpPgAdmin version 2.4.2 on a new linux server. We previously have been using 2.4-1 our current production server. With this new release I have found that on my left pane, the drop down entries for System Tables, All Databases open up with their entries already expanded, but...

I have a table (ABC) that has: pro varchar2(12) not null (primary key) pat varchar2(12) not null (primary key) ic1 varchar2(1) ic2 varchar2(1) ic3 varchar2(1) ic4 varchar2(1) If I want to create a view that will return a row for each ic type i could specify: create or replace view as select...

I have a table that looks something like this: protocol varchar2(12) not null - pk patient varchar2(12) not null - pk coldate date not null - pk testname varchar2(32) not null- pk testresult_num number(11,5) testresult_text varchar2(20) I would like to produce results that for each unique...

I am trying to find our where the information goes in the system catalog when you issue a command 'Grant select on table1 to user1'; I have been searching thru the pg_ catalog tables but have not been able to find it.......Thanks in advance for your help!

I have a postgres database on 2 different linux servers. the PHP application code resides on one of the servers. I am trying to use pg_connect like this: **** $conn = pg_connect ("hostaddr=$InServer port=5432 dbname=sag0s01 user=$InUser password=$InPassword"); **** where I pass in the...

I am trying to do a proof of concept to execute a Crystal Reports report program by clicking on a command button in Access. I have little experience with Access, and no knowledge of Visual Basic. From the documentation I have found, I created a Form in access with a command button. I have...

I am trying a proof of concept by using Access as the front end application, initiating calls to run a Crystal Report. I am new to Crystal Reports (unfortunately V5) and new to Access (with no Visual Basic expertise). Based on what I have read, I am trying the ActiveX implementation to create...