hi,
can i have a postgreSQl pl/sql function that can return multiple rows
may be the syntax will be like
create or replace function multiple() returns ...
begin
select candidateid...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Is there a way to read postgres log file(s)?
Thanks for your response
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Bay Breeze Software just released SQL Edge 3.0 to support auto-layout and multi-page ER diagrams. The ER diagram view now supports outline view, rulers, grid, page breaks, and multi-page print pre...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Navicat (PostgreSQL GUI) for Window ver. 7.2.11 is released [From PremiumSoft]
PremiumSoft released Navicat (PostgreSQL GUI) for Window version 7.2.11. This new version supports Database Role...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Navicat PostgreSQL GUI for Windows (ver. 7.2.9) includes bug fixes on Visual Query Builder and Backup/ Restore. This PostgreSQL Client tool features an intuitive interface and provides a set of u...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
SQL Edge is a universal SQL query tool that allows users to execute SQL queries, browse schema information in ER diagrams, and visualize data relationships. With SQL Edge, users can use only one q...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
SQL Edge™ is a SQL query tool that allows users to execute SQL queries, browse schema information in ER diagrams, and visualize data relationships. With SQL Edge™, users can use only one query to ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
Just want ask how to insert dates (e.g. day of month(1-31, day_of_week-1-7,day_name=Sunday to Saturday, month_name = Jan-Dec) to tables to be filled-up from 1-365.
Thanks.
jd
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
Whilst preparing a document to assist our technical team to migrate
from DB2 UDB to PostgreSQL, we found that there are several
differences in syntax & implementation between the two, ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I have to retrive the top n records in each group.
In Oracle I could achieve this easily using partition and rank function.
I need to achieve this same function using postgres.
T...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Is there an easyway to migrate db from 7.3.5 to 8.1.3 using LATIN9 encoding? ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I would like to modify a
varchar column (currency_varchar) in a
table (currency_Conversion)
example current values in column
$32.15
0.15
98.85
43215
6,644,232,121.42
Goal
Rem...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Designed, built and tested by a large and thriving community and backed by a growing number of corporate sponsors and support companies, version 8.1.1 will expand the scope of PostgreSQL application d...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I am trying to create my first function, however I seem
to be stumbling into a problem I do not know the solution
to.
I keep getting the following error message:
ERROR: relation &...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
how to write a query for finding all the employee-ids under a particular manager:
the table is :
emp
----
empid | ename | mid
----------------------
101 | a | 0 -CEO
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I am a newbie to postgresql. I want to read the transaction logs in postgresql.
is there any way to do this.
plz respond, I am in desperate need of a solution.
any kind of help is ap...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Our company has been using FreeBSD for many years since version 4.3 and we have found it to be very stable and reliable.
Since we have read many reports or article claiming Linux is faster especia...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
has anyone compiled postgreslq 8 for windows here?...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am working on a real time application.
I have a table which has 10000 rows and 31 columns.It is updated every 5 secs.But only a max of 5000 rows may be updated.And Updates effect only about 10 col...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
What's your opinion??
I have to collect information about this
Thanks in advance
Julia...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
