I have a gridview with a parameter that uses a dropdown to allow the user to select approved projects. So the Dropdown just has two values, yes and no. Works great. But now the users want the ...
I have the following query and I'm getting the following error.
UPDATE gp_blogs SET blog_noaccesses='8', blog_lastaccess='current_timestamp();' WHERE user_id='2'
Warning: pg_query() [fun...
I want to create a function that returs the number of records from a postgres database such as the following. The sql is dynamic as the table is created as the table is a partition.
CREATE...
I am trying to write a function that will give me the month's name when the numeric version is pass.
Create or replace Function nameofmonth(integer)
RETURNS text AS $$
select Case WHEN $1...
I'm trying to create a procedure that will assign a unique ID for a group of selected data. for example:
If I select the data below:
Table A
Tran_id Client date amount
101 ...
I have been asked to look into what would be required to port a sql server 2000 + db to Postgresql db.
In the sql server db we use a lot of functions, sps and views. What are the difference...
hello there,
i have a postgre db file which i want to restore.how can i do this from windows.the file is stored in at this path
C:\Documents and Settings\Zolf\Desktop\cws-0.3-bin\db-dump\c...
I have the directory postgresql 8.3.0 downloaded from internet..... I am new to postgresql.....I want to know how to install.........
my foldder postgresql 8.3.0 contains three subfolders ...
What is the best way to compare two PostgreSQL database schemas (DB structure - DDLs and data records)?
We are using PostgreSQL 8.1.9 on Linux (2 processors machine) (PostgreSQL 8.1.9 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-52)) in the production environ...
I am trying to write a PLPGSQL function which will return the next working day for a given date. However when I try to run the query:
select next_working_day('16/06/2008'); it gives me the ...
Hello,
can someone provide me with hints on how to store binary files with postgreSQL. I have followed this short perl tutorial. http://www.linuxconfig.org/Simple_Perl_example_how_to_store...
I would like to know in as much detail as possible an effective means of ensuring data integrity between a parent record and its associated child rows. For example:
I have a SALESORDER tab...
hi, im trying to peform calculation in my sql...
SELECT
company,
COUNT(booking.id) as bookings,
(COUNT(booking.id) / getTotalBookings('01/01/2008','12/01/2008') * 100) as pc,
....
Hi,
I'm trying to install PostgreSQL onto my linux Red Hat test environment. I downloaded all the required RPMs then looked at the PostgressQL documentation on hte site.
The docs there...
i need to ensure that postgres will return ordered strings in the same order that java would sort them.
javadoc: Compares two strings lexicographically. The comparison is based on the Unicod...
How do you transfer a table from one postgres db to another in Postgres 7.2.3-5.75.
Hi,
I'm new to PostgreSql and I'm used to use MS SQL Server.
I have some TSQL code which I want to convert to PlpgSql.
I've got some several questions as follows:
1. In MS SQL Serv...
Hi
I'm newbie to PostgreSQL and I downloaded the Postgres8.0 source from
postgres site. Im running Solaris 10.
I was able to run ./configure --without-readline.
When I ran gmake, I ...
I use a PosgreSQL 7.4 server on a FreeBSD OS (Unix)
I need to build a script to run in crontab (run it daily at 12 o'clock)
The script should do vacuuming and analyze my database.
So I thin...
We are unable to connect to a remote postgres installation on a server from another. We have tried stop iptables on both machines and adding an entry in the pb_hba.conf for the client wishing ...
If I use a query to get data from a ostgreSQL database table, the column order of the returned data is sorted alphabetically by column name. I'm using a JSTL (JSP) page to create XML-data, and...
Hi,
when executing a postgresql function/stored proc (like an update) I would like to have as return value the number of affected rows. Could someone, please, help me?
Thanks,
...
Hi.
I am trying to create a sql statement on a table that would calculate the standard deviation of the daily returns for each Ticker I send to the function.
table
Date Ti...
I need to reinstall/update postgres on my server, there are some path errors that appear on some tests. However it's been a long time since I've used postgres, and before backing up my databa...
