Serial Updating - Mailing list pgsql-general

From Bob Pawley
Subject Serial Updating
Date
Msg-id 005e01c6cf9f$60f66cf0$8e904618@owner
Whole thread Raw
Responses Re: Serial Updating  (Adrian Klaver <aklaver@comcast.net>)
Re: Serial Updating  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
I have a column that I wish to use to designate loop numbers.
 
A loop number is composed of a letter (F for flow, T for temperatures etc.) followed by a sequence number starting at one and ending with the last loop.
 
The loop numbers will appear as F-1, T-2 and so on.
 
I seem to have no problem designating the column with the appropriate letters.
 
However, I haven't a clue how to add the numerical portion - or if it is even possible.
 
If anyone has a thought I would appreciate being pointed to some documentation that covers this.
 
Bob Pawley
 
 

pgsql-general by date:

Previous
From: mdean
Date:
Subject: Re: [pgsql-advocacy] Thought provoking piece on NetBSD
Next
From: "Sean O'Loughlin"
Date:
Subject: Creating a date/time search function in Postgres.