Postgresql – Sélectionner les champs d’une colonne commençant par un chiffre

Postgresql - Sélectionner les champs d'une colonne commençant par un chiffre 1

Aide mémoire

La table adresse présentée ci-dessous est à remettre en forme en remettant les valeurs dans les bons champs. Un bon nombre de valeurs de libellevoie sont mal formées et nécessitent préalablement d’identifier les champs commençant par un nombre afin de reventiler les données.

Postgresql - Sélectionner les champs d'une colonne commençant par un chiffre 2

Pour les sélectionner, la requête est :

select * from origine 
where left(libellevoie, 1) ~ '^[0-9]*$'

Cette requête est utilisable ensuite dans un script d’update de la table où les valeurs sont réaffectées dans numvoie, puis dans typevoie en une passe.

 

Nick Kershaw – Wouldn’t it be good

Nick Kershaw - Wouldn't it be good 3

Ecrite, composée et interprétée par Nik Kershaw, la chanson Wouldn’t It Be Good extraite de l’album Human Racing rencontre à sa sortie un succès immédiat qui propulse le titre dans le top 10 des charts d’un bon paquet de pays dont le Royaume-Uni et la France.

Le titre sort le 21 janvier 1984.

Le clip est signé Storm Thorgerson, un pote photographe de Roger Waters et de Syd Barrett de chez les Pink Floyd, fondateur de Hipgnosis, un collectif de graphistes brittaniques.

Paroles :

I got it bad
You don’t know how bad I got it
You got it easy
You don’t know when you’ve got it goodIt’s getting harder
Just keeping life and soul together
I’m sick of fighting
Even though I know I shouldThe cold is biting
Through each and every nerve and fibre
My broken spirit is frozen to the core
I don’t wanna be here no moreWouldn’t it be good to be in your shoes
Even if it was for just one day?
Wouldn’t it be good if we could wish ourselves away?Wouldn’t it be good to be on your side?
The grass is always greener over there
Wouldn’t it be good if we could live without a care?You must be joking
You don’t know a thing about it
You’ve got no problem
I’d stay right there if I were youI got it harder
You couldn’t dream how hard I got it
Stay out of my shoes
If you know what’s good for youThe heat is stifling
Burning me up from the inside
The sweat is coming through each and every pore
I don’t wanna be here no more
I don’t wanna be here no more
I don’t wanna be here no moreWouldn’t it be good to be in your shoes
Even if it was for just one day?
Wouldn’t it be good if we could wish ourselves away?
Ooh-oohWouldn’t it be good to be on your side?
The grass is always greener over there
Wouldn’t it be good if we could live without a care?I got it bad
You don’t know how bad I got it
You got it easy
You don’t know when you’ve got it good
It’s getting harder
Just keeping life and soul together
I’m sick of fighting
Even though I know I should
I don’t wanna be here no more

Pointer Sisters – Automatic

Pointer Sisters - Automatic 4

Le 13 Janvier 1984, les Pointer Sisters sortent, sur le label « Planet », le second single de leur album « Break Out » sorti en 1983. Le titre, Automatic.

Un carton

Paroles :

Look what you’re doing to me
I’m utterly at your whim
All of my defenses downYour camera looks through me
With its X-ray vision
And all systems run agroundAll I can manage to push from my lips
Is a stream of absurdities
Every word I intended to speak
Winds up locked in the circuitry
No way to control it
It’s totally automatic
Whenever you’re around
I’m walking blindfolded
Completely automatic
All of my systems are down
Down, down, down
Automatic (automatic)
Automatic (automatic)
What is this madness
That makes my motor run
And my legs too weak to standI go from sadness
To exhilaration
Like a robot at your commandMy hands perspire and shake like a leaf
Up and down goes my temperature
I summon doctors to get some relief
But they tell me there is no cure
They tell me
No way to control it
It’s totally automatic
Whenever you’re around
I’m walking blindfolded
Completely automatic
All of my systems are down
Down, down, down
Automatic (automatic)
Automatic (automatic)Automatic
Automatic
Automatic
AutomaticLook what you’re doing to me
I’m utterly at your whim
All of my defenses downYour camera looks through me
With its X-ray vision
And all systems run agroundAll I can manage to push from my lips
Is a stream of absurdities
Every word I intended to speak
Winds up locked in the circuitry
No way to control it
It’s totally automatic
Whenever you’re around
I’m walking blindfolded
Completely automatic
All of my systems are down
Down, down, downNo way to control it
It’s totally automatic
Whenever you’re around
I’m walking blindfolded
Completely automatic
All of my systems are down
Down, down, downNo way to control it
It’s totally automatic

Chaka Khan – Fate

Chaka Khan - Fate 5

Le 15 avril 1981, Chaka Khan sort le titre Fate tiré de l’album What Cha’ Gonna Do for Me.

Ce titre ne remporte pas le succès attendu, eu égard à la célébrité de la chanteuse à l’époque. What Cha’ Gonna Do For Me est un pur album studio dans lequel Rufus ne trempe pas. Ceci explique peut-être cela.

Toujours est-il que ce titre présente un petit potentiel puisqu’il sera partiellement réexploité en 1998 par Stardust, le groupe d’un des Daft Punk, pour Music Sounds Better With You qui y trouve son get down.

Paroles :

When you walked into my lonely life tonight
I saw my destiny, I saw eternity tonight
And the moment I held you I knew it
What we do is decided before we do itFate, this could only be
Fate, I never thought I’d believe in
Fate, now I understand
It’s part of the plan
I was meant to be your womanTime stood still, and we lost on words to say
And though the people stared, they seemed a million miles away
Oh we knew it was love we were feeling
We were destined to give it a whole new meaningFate, this could only be
Fate, I never thought I’d believe in
Fate, now I understand
It’s part of the plan
I was meant to be your womanIn my heart I feel I’ve loved you all my life
I was in the dark, but now I think I’ve seen the light
I rang like a bell with your laughter
Something tells me I’ll love you forever and everFate (this could only be)
It was fate (this could only be)
It’s part of the plan
I was meant to be your woman
(It’s part of the plan)
I’ll love you forever and ever

La reprise du sample :