August 21, 2008 05:48pm pdt

Member Login

Hall of Fame

Yearly

1angelIII 798,580
2ee_rlee 458,453
3capricorn1 351,496
4mark_wills 322,678
5chapmandew 316,112
6aneeshatti... 188,921
7matthews... 186,746
8Thomasian 170,076
9jinesh_ka... 167,181
10sdstuber 140,527
11jimhorn 120,720
12peter57r 117,305
13harfang 108,183
14frankytee 107,144
15DatabaseMX 97,397
16hielo 86,250
17TextReport 84,195
18boag2000 77,858
19GRayL 77,734
20ScottPletc... 77,436
21cactus_d... 73,646
22dqmq 70,815
23dtodd 62,424
24LSMCons... 61,900
25asvforce 57,585

	[x] Attachment Details

Record ID for database View

Zones: SQL Query Syntax, Databases Miscellaneous, PostgreSQL Database

Tags: SQL VIEW, postgresql

I need a Unique Id column in my views. The views are created from select statement from more than one table/view each having a unique ID. I need a unique static id for each of the record in the View. Is that possible? For now what I'm doing is like

select a.id*10000+b.id*100+c.id as id, .........

But you can see that the id will be unique as long as id of b and c are <100

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.6

Question Stats

Zone: Programming

Question Asked By: sinoj

Solution Provided By: mark_wills

Participating Experts: 3

Solution Grade: A

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_EXPERT_20070906